eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_CORE_UTILS

Line 2291: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = c_financial_year

2287: and paas.action_status ='C'
2288: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
2289: and pail.locking_action_id = paat.assignment_action_id
2290: and paat.payroll_action_id = paas.payroll_action_id
2291: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = c_financial_year
2292: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = p_tax_unit_id; --2610141
2293:
2294:
2295: CURSOR c_get_details(c_assignment_id per_all_assignments_f.assignment_id%type,

Line 2292: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = p_tax_unit_id; --2610141

2288: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
2289: and pail.locking_action_id = paat.assignment_action_id
2290: and paat.payroll_action_id = paas.payroll_action_id
2291: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = c_financial_year
2292: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = p_tax_unit_id; --2610141
2293:
2294:
2295: CURSOR c_get_details(c_assignment_id per_all_assignments_f.assignment_id%type,
2296: c_financial_yr_end date)

Line 2947: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')

2943:
2944:
2945: cursor get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
2946: is
2947: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
2948: Financial_year_start
2949: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY')
2950: Financial_year_end
2951: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')

Line 2949: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY')

2945: cursor get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
2946: is
2947: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
2948: Financial_year_start
2949: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY')
2950: Financial_year_end
2951: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
2952: FBT_year_start
2953: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')

Line 2951: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')

2947: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
2948: Financial_year_start
2949: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY')
2950: Financial_year_end
2951: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
2952: FBT_year_start
2953: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
2954: FBT_year_end
2955: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')

Line 2953: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')

2949: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY')
2950: Financial_year_end
2951: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
2952: FBT_year_start
2953: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
2954: FBT_year_end
2955: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')
2956: Employee_type
2957: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer

Line 2955: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')

2951: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
2952: FBT_year_start
2953: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
2954: FBT_year_end
2955: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')
2956: Employee_type
2957: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
2958: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
2959: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id

Line 2957: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer

2953: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
2954: FBT_year_end
2955: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')
2956: Employee_type
2957: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
2958: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
2959: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id
2960: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*Bug3661230*/
2961: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id

Line 2958: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id

2954: FBT_year_end
2955: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')
2956: Employee_type
2957: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
2958: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
2959: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id
2960: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*Bug3661230*/
2961: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
2962: from pay_payroll_actions

Line 2959: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id

2955: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')
2956: Employee_type
2957: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
2958: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
2959: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id
2960: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*Bug3661230*/
2961: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
2962: from pay_payroll_actions
2963: where payroll_action_id =c_payroll_Action_id;

Line 2960: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /Bug3661230/

2956: Employee_type
2957: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
2958: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
2959: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id
2960: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*Bug3661230*/
2961: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
2962: from pay_payroll_actions
2963: where payroll_action_id =c_payroll_Action_id;
2964:

Line 2961: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id

2957: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
2958: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
2959: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id
2960: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*Bug3661230*/
2961: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
2962: from pay_payroll_actions
2963: where payroll_action_id =c_payroll_Action_id;
2964:
2965: cursor next_action_id is

Line 3470: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year

3466: --------------------------------------------------------------------+
3467:
3468: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
3469: IS
3470: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
3471: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
3472: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
3473: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
3474: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id

Line 3471: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type

3467:
3468: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
3469: IS
3470: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
3471: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
3472: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
3473: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
3474: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
3475: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term

Line 3472: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer

3468: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
3469: IS
3470: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
3471: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
3472: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
3473: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
3474: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
3475: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
3476: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id

Line 3473: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id

3469: IS
3470: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
3471: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
3472: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
3473: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
3474: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
3475: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
3476: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
3477: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */

Line 3474: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id

3470: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
3471: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
3472: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
3473: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
3474: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
3475: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
3476: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
3477: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
3478: from pay_payroll_actions

Line 3475: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term

3471: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
3472: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
3473: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
3474: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
3475: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
3476: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
3477: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
3478: from pay_payroll_actions
3479: where payroll_action_id =c_payroll_Action_id;

Line 3476: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id

3472: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
3473: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
3474: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
3475: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
3476: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
3477: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
3478: from pay_payroll_actions
3479: where payroll_action_id =c_payroll_Action_id;
3480:

Line 3477: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */

3473: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
3474: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
3475: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
3476: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
3477: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
3478: from pay_payroll_actions
3479: where payroll_action_id =c_payroll_Action_id;
3480:
3481: