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.

[Home] [Help]

APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_CORE_UTILS

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

1222: and paas.action_status ='C'
1223: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
1224: and pail.locking_action_id = paat.assignment_action_id
1225: and paat.payroll_action_id = paas.payroll_action_id
1226: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = c_financial_year
1227: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = p_tax_unit_id; --2610141
1228:
1229:
1230: CURSOR c_get_details(c_assignment_id per_all_assignments_f.assignment_id%type,

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

1223: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
1224: and pail.locking_action_id = paat.assignment_action_id
1225: and paat.payroll_action_id = paas.payroll_action_id
1226: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = c_financial_year
1227: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = p_tax_unit_id; --2610141
1228:
1229:
1230: CURSOR c_get_details(c_assignment_id per_all_assignments_f.assignment_id%type,
1231: c_financial_yr_end date)

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

1727:
1728:
1729: cursor get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
1730: is
1731: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
1732: Financial_year_start
1733: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY')
1734: Financial_year_end
1735: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')

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

1729: cursor get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
1730: is
1731: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
1732: Financial_year_start
1733: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY')
1734: Financial_year_end
1735: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
1736: FBT_year_start
1737: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')

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

1731: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
1732: Financial_year_start
1733: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY')
1734: Financial_year_end
1735: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
1736: FBT_year_start
1737: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
1738: FBT_year_end
1739: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')

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

1733: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY')
1734: Financial_year_end
1735: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
1736: FBT_year_start
1737: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
1738: FBT_year_end
1739: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')
1740: Employee_type
1741: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer

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

1735: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
1736: FBT_year_start
1737: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
1738: FBT_year_end
1739: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')
1740: Employee_type
1741: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1742: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1743: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id

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

1737: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY')
1738: FBT_year_end
1739: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')
1740: Employee_type
1741: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1742: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1743: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id
1744: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*Bug3661230*/
1745: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id

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

1738: FBT_year_end
1739: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')
1740: Employee_type
1741: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1742: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1743: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id
1744: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*Bug3661230*/
1745: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
1746: from pay_payroll_actions

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

1739: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%')
1740: Employee_type
1741: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1742: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1743: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id
1744: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*Bug3661230*/
1745: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
1746: from pay_payroll_actions
1747: where payroll_action_id =c_payroll_Action_id;

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

1740: Employee_type
1741: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1742: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1743: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id
1744: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*Bug3661230*/
1745: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
1746: from pay_payroll_actions
1747: where payroll_action_id =c_payroll_Action_id;
1748:

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

1741: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1742: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1743: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id
1744: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*Bug3661230*/
1745: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
1746: from pay_payroll_actions
1747: where payroll_action_id =c_payroll_Action_id;
1748:
1749: cursor next_action_id is

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

2225: --------------------------------------------------------------------+
2226:
2227: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2228: IS
2229: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
2230: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
2231: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
2232: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
2233: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id

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

2226:
2227: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2228: IS
2229: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
2230: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
2231: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
2232: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
2233: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
2234: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term

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

2227: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2228: IS
2229: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
2230: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
2231: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
2232: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
2233: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
2234: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
2235: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id

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

2228: IS
2229: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
2230: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
2231: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
2232: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
2233: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
2234: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
2235: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
2236: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */

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

2229: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
2230: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
2231: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
2232: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
2233: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
2234: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
2235: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
2236: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
2237: from pay_payroll_actions

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

2230: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
2231: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
2232: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
2233: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
2234: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
2235: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
2236: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
2237: from pay_payroll_actions
2238: where payroll_action_id =c_payroll_Action_id;

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

2231: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
2232: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
2233: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
2234: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
2235: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
2236: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
2237: from pay_payroll_actions
2238: where payroll_action_id =c_payroll_Action_id;
2239:

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

2232: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
2233: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
2234: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
2235: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
2236: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
2237: from pay_payroll_actions
2238: where payroll_action_id =c_payroll_Action_id;
2239:
2240: