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_PAYMENT_SUMMARY dependencies on PAY_CORE_UTILS

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

601: AND effective_end_date;
602:
603: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
604: IS
605: SELECT to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
606: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters) registered_employer /*bug9147430*/
607: ,ppa.business_group_id
608: FROM pay_payroll_actions ppa
609: WHERE ppa.payroll_action_id = c_payroll_Action_id;

Line 606: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters) registered_employer /bug9147430/

602:
603: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
604: IS
605: SELECT to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
606: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters) registered_employer /*bug9147430*/
607: ,ppa.business_group_id
608: FROM pay_payroll_actions ppa
609: WHERE ppa.payroll_action_id = c_payroll_Action_id;
610:

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

1145: -- cursor to get the archive parameters
1146: ----------------------------------------------+
1147: cursor get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
1148: is
1149: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
1150: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
1151: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
1152: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
1153: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type

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

1146: ----------------------------------------------+
1147: cursor get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
1148: is
1149: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
1150: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
1151: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
1152: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
1153: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
1154: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer

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

1147: cursor get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
1148: is
1149: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
1150: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
1151: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
1152: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
1153: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
1154: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1155: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year

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

1148: is
1149: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
1150: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
1151: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
1152: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
1153: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
1154: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1155: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
1156: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%',

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

1149: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
1150: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
1151: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
1152: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
1153: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
1154: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1155: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
1156: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%',
1157: pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id

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

1150: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
1151: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
1152: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
1153: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
1154: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1155: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
1156: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%',
1157: pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1158: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id

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

1151: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
1152: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
1153: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
1154: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1155: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
1156: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%',
1157: pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1158: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
1159: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/

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

1152: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
1153: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
1154: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1155: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
1156: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%',
1157: pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1158: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
1159: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
1160: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id

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

1153: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
1154: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1155: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
1156: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%',
1157: pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1158: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
1159: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
1160: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
1161: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),null,'%',

Line 1158: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id

1154: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
1155: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
1156: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%',
1157: pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1158: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
1159: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
1160: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
1161: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),null,'%',
1162: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)) Assignment_set_id /*Bug 13043341*/

Line 1159: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /3661230/

1155: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
1156: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%',
1157: pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1158: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
1159: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
1160: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
1161: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),null,'%',
1162: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)) Assignment_set_id /*Bug 13043341*/
1163: from pay_payroll_actions

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

1156: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%',
1157: pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1158: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
1159: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
1160: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
1161: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),null,'%',
1162: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)) Assignment_set_id /*Bug 13043341*/
1163: from pay_payroll_actions
1164: where payroll_action_id = c_payroll_Action_id;

Line 1161: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),null,'%',

1157: pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1158: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
1159: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
1160: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
1161: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),null,'%',
1162: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)) Assignment_set_id /*Bug 13043341*/
1163: from pay_payroll_actions
1164: where payroll_action_id = c_payroll_Action_id;
1165:

Line 1162: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)) Assignment_set_id /Bug 13043341/

1158: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
1159: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
1160: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
1161: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),null,'%',
1162: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)) Assignment_set_id /*Bug 13043341*/
1163: from pay_payroll_actions
1164: where payroll_action_id = c_payroll_Action_id;
1165:
1166: ----------------------------------------------+

Line 1248: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year

1244: and paas.action_status ='C'
1245: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
1246: and pail.locking_action_id = paat.assignment_action_id
1247: and paat.payroll_action_id = paas.payroll_action_id
1248: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1249: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
1250: )
1251: and not exists ( select aei_information1
1252: from per_assignment_extra_info,

Line 1249: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp

1245: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
1246: and pail.locking_action_id = paat.assignment_action_id
1247: and paat.payroll_action_id = paas.payroll_action_id
1248: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1249: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
1250: )
1251: and not exists ( select aei_information1
1252: from per_assignment_extra_info,
1253: hr_lookups

Line 1343: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year

1339: and paas.action_status ='C'
1340: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
1341: and pail.locking_action_id = paat.assignment_action_id
1342: and paat.payroll_action_id = paas.payroll_action_id
1343: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1344: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp) --2610141
1345: and not exists ( select aei_information1
1346: from per_assignment_extra_info,
1347: hr_lookups

Line 1344: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp) --2610141

1340: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
1341: and pail.locking_action_id = paat.assignment_action_id
1342: and paat.payroll_action_id = paas.payroll_action_id
1343: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1344: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp) --2610141
1345: and not exists ( select aei_information1
1346: from per_assignment_extra_info,
1347: hr_lookups
1348: where assignment_id = a.assignment_id

Line 1451: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year

1447: AND paas.action_status ='C'
1448: AND paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
1449: AND pail.locking_action_id = paat.assignment_action_id
1450: AND paat.payroll_action_id = paas.payroll_action_id
1451: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1452: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
1453: )
1454: AND NOT EXISTS
1455: ( SELECT aei_information1

Line 1452: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp

1448: AND paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
1449: AND pail.locking_action_id = paat.assignment_action_id
1450: AND paat.payroll_action_id = paas.payroll_action_id
1451: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1452: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
1453: )
1454: AND NOT EXISTS
1455: ( SELECT aei_information1
1456: FROM per_assignment_extra_info,

Line 1590: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year

1586: AND paas.action_status ='C'
1587: AND paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
1588: AND pail.locking_action_id = paat.assignment_action_id
1589: AND paat.payroll_action_id = paas.payroll_action_id
1590: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1591: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
1592: )
1593: AND NOT EXISTS
1594: ( SELECT aei_information1

Line 1591: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp

1587: AND paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
1588: AND pail.locking_action_id = paat.assignment_action_id
1589: AND paat.payroll_action_id = paas.payroll_action_id
1590: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1591: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
1592: )
1593: AND NOT EXISTS
1594: ( SELECT aei_information1
1595: FROM per_assignment_extra_info,

Line 1687: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year

1683: and paas.action_status ='C'
1684: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
1685: and pail.locking_action_id = paat.assignment_action_id
1686: and paat.payroll_action_id = paas.payroll_action_id
1687: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1688: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
1689: )
1690: and not exists ( select aei_information1
1691: from per_assignment_extra_info,

Line 1688: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp

1684: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'
1685: and pail.locking_action_id = paat.assignment_action_id
1686: and paat.payroll_action_id = paas.payroll_action_id
1687: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
1688: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
1689: )
1690: and not exists ( select aei_information1
1691: from per_assignment_extra_info,
1692: hr_lookups

Line 8071: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters)

8067: -- Cursor to get details for assignment action id
8068: -------------------------------------------------+
8069: --
8070: cursor c_action(c_assignment_action_id number) is
8071: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters)
8072: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)
8073: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
8074: , ppa.payroll_action_id
8075: , paa.assignment_id

Line 8072: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)

8068: -------------------------------------------------+
8069: --
8070: cursor c_action(c_assignment_action_id number) is
8071: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters)
8072: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)
8073: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
8074: , ppa.payroll_action_id
8075: , paa.assignment_id
8076: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')

Line 8073: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)

8069: --
8070: cursor c_action(c_assignment_action_id number) is
8071: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters)
8072: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)
8073: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
8074: , ppa.payroll_action_id
8075: , paa.assignment_id
8076: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
8077: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')

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

8072: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)
8073: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
8074: , ppa.payroll_action_id
8075: , paa.assignment_id
8076: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
8077: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
8078: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters) /*Bug3661230*/
8079: from pay_assignment_actions paa
8080: , pay_payroll_actions ppa

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

8073: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
8074: , ppa.payroll_action_id
8075: , paa.assignment_id
8076: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
8077: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
8078: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters) /*Bug3661230*/
8079: from pay_assignment_actions paa
8080: , pay_payroll_actions ppa
8081: where paa.assignment_action_id = c_assignment_action_id

Line 8078: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters) /Bug3661230/

8074: , ppa.payroll_action_id
8075: , paa.assignment_id
8076: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
8077: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
8078: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters) /*Bug3661230*/
8079: from pay_assignment_actions paa
8080: , pay_payroll_actions ppa
8081: where paa.assignment_action_id = c_assignment_action_id
8082: and ppa.payroll_action_id = paa.payroll_action_id ;

Line 9418: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,

9414: --------------------------------------------------------------------+
9415:
9416: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
9417: IS
9418: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
9419: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
9420: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
9421: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
9422: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,

Line 9419: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,

9415:
9416: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
9417: IS
9418: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
9419: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
9420: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
9421: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
9422: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
9423: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,

Line 9420: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,

9416: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
9417: IS
9418: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
9419: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
9420: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
9421: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
9422: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
9423: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
9424: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE

Line 9421: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,

9417: IS
9418: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
9419: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
9420: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
9421: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
9422: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
9423: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
9424: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
9425: FROM pay_payroll_actions ppa

Line 9422: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,

9418: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
9419: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
9420: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
9421: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
9422: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
9423: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
9424: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
9425: FROM pay_payroll_actions ppa
9426: WHERE ppa.payroll_action_id = c_payroll_action_id;

Line 9423: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,

9419: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
9420: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
9421: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
9422: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
9423: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
9424: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
9425: FROM pay_payroll_actions ppa
9426: WHERE ppa.payroll_action_id = c_payroll_action_id;
9427:

Line 9424: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE

9420: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
9421: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
9422: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
9423: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
9424: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
9425: FROM pay_payroll_actions ppa
9426: WHERE ppa.payroll_action_id = c_payroll_action_id;
9427:
9428: