PAY Pay Advice (Singapore)

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Pay Advice (Singapore)
Application: Payroll
Source: Pay Advice (Singapore) (XML)
Short Name: PAYSGSOE_XML
DB package: PAY_PAYSGSOE_XMLP_PKG
Run PAY Pay Advice (Singapore) and other Oracle EBS reports with Blitz Report™ on our demo environment
select assignment_id,
          assignment_action_id,
          person_id,
          full_name,
          assignment_number,
          position_title,
          salary,
          location_id,
          location_code,
          expense_check_send_to_address,
          legal_employer,
          payroll_id,
          payroll_action_id,
          time_period_id,
          period_number,
          to_char(period_start_date,'DD-Mon-YYYY') period_start_date,
          to_char(period_end_date,'DD-Mon-YYYY') period_end_date,
          to_char(pay_advice_date,'DD-Mon-YYYY') pay_advice_date,
          to_char(date_earned,'DD-Mon-YYYY') date_earned,
          run_assignment_action_id,
          run_payroll_action_id, 
	PAY_PAYSGSOE_XMLP_PKG.cf_address_line1formula(expense_check_send_to_address, person_id, location_id) CF_ADDRESS_LINE1, 
	PAY_PAYSGSOE_XMLP_PKG.cf_gross_pay_currformula(assignment_action_id, person_id) CF_GROSS_PAY_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_ADDRESS_LINE2_p CP_ADDRESS_LINE2,
	PAY_PAYSGSOE_XMLP_PKG.CP_ADDRESS_LINE3_p CP_ADDRESS_LINE3,
	PAY_PAYSGSOE_XMLP_PKG.CP_TOWN_p CP_TOWN,
	PAY_PAYSGSOE_XMLP_PKG.CP_POST_CODE_p CP_POST_CODE,
	PAY_PAYSGSOE_XMLP_PKG.CP_COUNTRY_p CP_COUNTRY,
	PAY_PAYSGSOE_XMLP_PKG.CP_GROSS_PAY_YTD_p CP_GROSS_PAY_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_STAT_DED_CURR_p CP_STAT_DED_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_STAT_DED_YTD_p CP_STAT_DED_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_OTHER_CURR_p CP_OTHER_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_OTHER_YTD_p CP_OTHER_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_NON_PAY_CURR_p CP_NON_PAY_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_NON_PAY_YTD_p CP_NON_PAY_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_NET_PAY_CURR_p CP_NET_PAY_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_NET_PAY_YTD_p CP_NET_PAY_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_EMPLOYEE_CPF_CURR_p CP_EMPLOYEE_CPF_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_EMPLOYEE_CPF_YTD_p CP_EMPLOYEE_CPF_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_EMPLOYER_CPF_CURR_p CP_EMPLOYER_CPF_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_EMPLOYER_CPF_YTD_p CP_EMPLOYER_CPF_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_TOTAL_CPF_CURR_p CP_TOTAL_CPF_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_TOTAL_CPF_YTD_p CP_TOTAL_CPF_YTD
from   pay_sg_asg_payment_runs_v
where business_group_id = :p_business_group_id
and     payroll_id              = :p_payroll_id
and     payroll_action_id   = :p_payroll_action_id
&cp_where_clause
&cp_order_by
Parameter Name SQL text Validation
Payroll 
 
 LOV Oracle
Payment Run 
 
 LOV Oracle
Organization 
 
 LOV Oracle
Location 
 
 LOV Oracle
Assignment Number 
 
 LOV Oracle
Sort Order 1 
 
 LOV Oracle
Sort Order 2 
 
 LOV Oracle
Sort Order 3 
 
 LOV Oracle
Sort Order 4 
 
 LOV Oracle
Download
Related Blitz Reports
PAY Pay Advice (Hong Kong) PAY Statement Of Earnings (New Zealand) PAY Pay Advice (Australia) ECC Projects, Projects Costing: Transactions, SQL1 PAY ROE Work Sheet PAY Tax Payments Listing PAY STP Archive Validation PAY IR8S Ad Hoc Printed Report New PAY End of Year Reconciliation Detail
Blitz Report™

Blitz Report™ provides multiple benefits: