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

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

169: l_procedure VARCHAR2(80);
170:
171: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%TYPE)
172: IS
173: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
174: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
175: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
176: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
177: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type

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

170:
171: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%TYPE)
172: IS
173: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
174: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
175: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
176: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
177: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
178: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer

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

171: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%TYPE)
172: IS
173: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
174: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
175: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
176: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
177: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
178: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
179: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year

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

172: IS
173: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
174: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
175: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
176: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
177: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
178: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
179: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
180: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id

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

173: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
174: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
175: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
176: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
177: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
178: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
179: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
180: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
181: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id

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

174: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
175: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
176: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
177: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
178: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
179: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
180: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
181: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
182: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/

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

175: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
176: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
177: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
178: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
179: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
180: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
181: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
182: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
183: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id

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

176: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
177: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
178: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
179: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
180: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
181: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
182: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
183: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
184: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id

Line 181: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id

177: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
178: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
179: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
180: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
181: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
182: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
183: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
184: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id
185: FROM pay_payroll_actions

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

178: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
179: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
180: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
181: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
182: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
183: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
184: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id
185: FROM pay_payroll_actions
186: WHERE payroll_action_id = c_payroll_Action_id;

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

179: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
180: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
181: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
182: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
183: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
184: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id
185: FROM pay_payroll_actions
186: WHERE payroll_action_id = c_payroll_Action_id;
187:

Line 184: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id

180: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
181: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
182: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
183: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
184: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id
185: FROM pay_payroll_actions
186: WHERE payroll_action_id = c_payroll_Action_id;
187:
188: CURSOR process_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

Line 214: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year

210: AND ppa1.report_type = 'AU_PS_DATA_FILE'
211: AND ppa1.report_qualifier = 'AU'
212: AND ppa1.report_category = 'REPORT'
213: AND paa1.assignment_id = paf.assignment_id
214: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
215: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
216: )
217: AND NOT EXISTS
218: ( /* Check if a locked Amended Payment Summary does not exist for this year */

Line 215: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id

211: AND ppa1.report_qualifier = 'AU'
212: AND ppa1.report_category = 'REPORT'
213: AND paa1.assignment_id = paf.assignment_id
214: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
215: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
216: )
217: AND NOT EXISTS
218: ( /* Check if a locked Amended Payment Summary does not exist for this year */
219: SELECT '1'

Line 227: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year

223: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
224: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
225: AND ppa2.report_qualifier = 'AU'
226: AND ppa2.report_category = 'REPORT'
227: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year
228: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa2.legislative_parameters) = c_tax_unit_id
229: AND paa2.assignment_id = paf.assignment_id
230: AND pai.locked_action_id = paa2.assignment_action_id
231: );

Line 228: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa2.legislative_parameters) = c_tax_unit_id

224: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
225: AND ppa2.report_qualifier = 'AU'
226: AND ppa2.report_category = 'REPORT'
227: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year
228: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa2.legislative_parameters) = c_tax_unit_id
229: AND paa2.assignment_id = paf.assignment_id
230: AND pai.locked_action_id = paa2.assignment_action_id
231: );
232:

Line 263: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year

259: AND ppa1.report_type = 'AU_PS_DATA_FILE'
260: AND ppa1.report_qualifier = 'AU'
261: AND ppa1.report_category = 'REPORT'
262: AND paa1.assignment_id = paf.assignment_id
263: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
264: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
265: )
266: AND NOT EXISTS
267: ( /* Check if a locked Amended Payment Summary does not exist for this year */

Line 264: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id

260: AND ppa1.report_qualifier = 'AU'
261: AND ppa1.report_category = 'REPORT'
262: AND paa1.assignment_id = paf.assignment_id
263: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
264: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
265: )
266: AND NOT EXISTS
267: ( /* Check if a locked Amended Payment Summary does not exist for this year */
268: SELECT '1'

Line 276: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year

272: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
273: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
274: AND ppa2.report_qualifier = 'AU'
275: AND ppa2.report_category = 'REPORT'
276: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year
277: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa2.legislative_parameters) = c_tax_unit_id
278: AND paa2.assignment_id = paf.assignment_id
279: AND pai.locked_action_id = paa2.assignment_action_id
280: );

Line 277: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa2.legislative_parameters) = c_tax_unit_id

273: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
274: AND ppa2.report_qualifier = 'AU'
275: AND ppa2.report_category = 'REPORT'
276: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year
277: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa2.legislative_parameters) = c_tax_unit_id
278: AND paa2.assignment_id = paf.assignment_id
279: AND pai.locked_action_id = paa2.assignment_action_id
280: );
281:

Line 1469: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',mppa.legislative_parameters) = c_fin_year

1465: AND mpaa.payroll_action_id = mppa.payroll_action_id
1466: AND mppa.report_type = 'AU_PS_DATA_FILE'
1467: AND mppa.report_qualifier = 'AU'
1468: AND mppa.report_category = 'REPORT'
1469: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',mppa.legislative_parameters) = c_fin_year
1470: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mppa.legislative_parameters) = c_tax_unit_id
1471: AND mplock.locking_action_id = mpaa.assignment_action_id
1472: AND mplock.locked_action_id = selfplock.locking_action_id;
1473:

Line 1470: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mppa.legislative_parameters) = c_tax_unit_id

1466: AND mppa.report_type = 'AU_PS_DATA_FILE'
1467: AND mppa.report_qualifier = 'AU'
1468: AND mppa.report_category = 'REPORT'
1469: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',mppa.legislative_parameters) = c_fin_year
1470: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mppa.legislative_parameters) = c_tax_unit_id
1471: AND mplock.locking_action_id = mpaa.assignment_action_id
1472: AND mplock.locked_action_id = selfplock.locking_action_id;
1473:
1474:

Line 1476: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters)

1472: AND mplock.locked_action_id = selfplock.locking_action_id;
1473:
1474:
1475: CURSOR c_action(c_assignment_action_id NUMBER) IS
1476: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters)
1477: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)
1478: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
1479: , ppa.payroll_action_id
1480: , paa.assignment_id

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

1473:
1474:
1475: CURSOR c_action(c_assignment_action_id NUMBER) IS
1476: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters)
1477: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)
1478: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
1479: , ppa.payroll_action_id
1480: , paa.assignment_id
1481: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')

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

1474:
1475: CURSOR c_action(c_assignment_action_id NUMBER) IS
1476: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters)
1477: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)
1478: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
1479: , ppa.payroll_action_id
1480: , paa.assignment_id
1481: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
1482: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')

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

1477: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)
1478: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
1479: , ppa.payroll_action_id
1480: , paa.assignment_id
1481: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
1482: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
1483: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters)
1484: , pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters)
1485: FROM pay_assignment_actions paa

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

1478: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
1479: , ppa.payroll_action_id
1480: , paa.assignment_id
1481: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
1482: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
1483: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters)
1484: , pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters)
1485: FROM pay_assignment_actions paa
1486: , pay_payroll_actions ppa

Line 1483: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters)

1479: , ppa.payroll_action_id
1480: , paa.assignment_id
1481: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
1482: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
1483: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters)
1484: , pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters)
1485: FROM pay_assignment_actions paa
1486: , pay_payroll_actions ppa
1487: WHERE paa.assignment_action_id = c_assignment_action_id

Line 1484: , pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters)

1480: , paa.assignment_id
1481: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
1482: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
1483: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters)
1484: , pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters)
1485: FROM pay_assignment_actions paa
1486: , pay_payroll_actions ppa
1487: WHERE paa.assignment_action_id = c_assignment_action_id
1488: AND ppa.payroll_action_id = paa.payroll_action_id ;

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

1724: --------------------------------------------------------------------+
1725:
1726: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1727: IS
1728: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
1729: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
1730: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
1731: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
1732: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,

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

1725:
1726: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1727: IS
1728: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
1729: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
1730: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
1731: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
1732: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
1733: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

1726: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1727: IS
1728: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
1729: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
1730: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
1731: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
1732: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
1733: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
1734: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE

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

1727: IS
1728: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
1729: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
1730: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
1731: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
1732: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
1733: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
1734: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
1735: FROM pay_payroll_actions ppa

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

1728: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
1729: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
1730: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
1731: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
1732: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
1733: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
1734: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
1735: FROM pay_payroll_actions ppa
1736: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

1729: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
1730: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
1731: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
1732: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
1733: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
1734: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
1735: FROM pay_payroll_actions ppa
1736: WHERE ppa.payroll_action_id = c_payroll_action_id;
1737:

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

1730: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
1731: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
1732: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
1733: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
1734: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
1735: FROM pay_payroll_actions ppa
1736: WHERE ppa.payroll_action_id = c_payroll_action_id;
1737:
1738: