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 252: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start

248: l_procedure VARCHAR2(80);
249:
250: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%TYPE)
251: IS
252: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
253: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
254: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
255: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
256: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type

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

249:
250: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%TYPE)
251: IS
252: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
253: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
254: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
255: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
256: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
257: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer

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

250: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%TYPE)
251: IS
252: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
253: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
254: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
255: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
256: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
257: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
258: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year

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

251: IS
252: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
253: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
254: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
255: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
256: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
257: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
258: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
259: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id

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

252: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
253: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
254: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
255: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
256: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
257: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
258: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
259: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
260: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id

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

253: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
254: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
255: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
256: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
257: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
258: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
259: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
260: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
261: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/

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

254: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start
255: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
256: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
257: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
258: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
259: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
260: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
261: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
262: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id

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

255: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_end
256: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
257: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
258: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
259: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
260: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
261: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
262: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
263: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id

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

256: ,decode(pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters),'C','Y','T','N','B','%') Employee_type
257: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
258: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
259: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
260: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
261: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
262: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
263: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id
264: ,pay_core_utils.get_parameter('MULTIPLE_AMENDED',legislative_parameters) multiple_amended /*14621185*/

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

257: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) Registered_Employer
258: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
259: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
260: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
261: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
262: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
263: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id
264: ,pay_core_utils.get_parameter('MULTIPLE_AMENDED',legislative_parameters) multiple_amended /*14621185*/
265: FROM pay_payroll_actions

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

258: ,pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
259: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
260: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
261: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
262: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
263: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id
264: ,pay_core_utils.get_parameter('MULTIPLE_AMENDED',legislative_parameters) multiple_amended /*14621185*/
265: FROM pay_payroll_actions
266: WHERE payroll_action_id = c_payroll_Action_id;

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

259: ,pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters) Assignment_id
260: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
261: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
262: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
263: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id
264: ,pay_core_utils.get_parameter('MULTIPLE_AMENDED',legislative_parameters) multiple_amended /*14621185*/
265: FROM pay_payroll_actions
266: WHERE payroll_action_id = c_payroll_Action_id;
267:

Line 264: ,pay_core_utils.get_parameter('MULTIPLE_AMENDED',legislative_parameters) multiple_amended /14621185/

260: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
261: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
262: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
263: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id
264: ,pay_core_utils.get_parameter('MULTIPLE_AMENDED',legislative_parameters) multiple_amended /*14621185*/
265: FROM pay_payroll_actions
266: WHERE payroll_action_id = c_payroll_Action_id;
267:
268: CURSOR process_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

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

290: AND ppa1.report_type = 'AU_PS_DATA_FILE'
291: AND ppa1.report_qualifier = 'AU'
292: AND ppa1.report_category = 'REPORT'
293: AND paa1.assignment_id = paf.assignment_id
294: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
295: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
296: )
297: AND NOT EXISTS
298: ( /* Check if a locked Amended Payment Summary does not exist for this year */

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

291: AND ppa1.report_qualifier = 'AU'
292: AND ppa1.report_category = 'REPORT'
293: AND paa1.assignment_id = paf.assignment_id
294: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
295: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
296: )
297: AND NOT EXISTS
298: ( /* Check if a locked Amended Payment Summary does not exist for this year */
299: SELECT '1'

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

303: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
304: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
305: AND ppa2.report_qualifier = 'AU'
306: AND ppa2.report_category = 'REPORT'
307: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year
308: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa2.legislative_parameters) = c_tax_unit_id
309: AND paa2.assignment_id = paf.assignment_id
310: AND pai.locked_action_id = paa2.assignment_action_id
311: );

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

304: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
305: AND ppa2.report_qualifier = 'AU'
306: AND ppa2.report_category = 'REPORT'
307: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year
308: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa2.legislative_parameters) = c_tax_unit_id
309: AND paa2.assignment_id = paf.assignment_id
310: AND pai.locked_action_id = paa2.assignment_action_id
311: );
312:

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

336: AND ppa1.report_type = 'AU_PS_DATA_FILE'
337: AND ppa1.report_qualifier = 'AU'
338: AND ppa1.report_category = 'REPORT'
339: AND paa1.assignment_id = paf.assignment_id
340: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
341: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
342: )
343: ;
344:

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

337: AND ppa1.report_qualifier = 'AU'
338: AND ppa1.report_category = 'REPORT'
339: AND paa1.assignment_id = paf.assignment_id
340: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
341: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
342: )
343: ;
344:
345: CURSOR process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

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

370: AND ppa1.report_type = 'AU_PS_DATA_FILE'
371: AND ppa1.report_qualifier = 'AU'
372: AND ppa1.report_category = 'REPORT'
373: AND paa1.assignment_id = paf.assignment_id
374: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
375: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
376: )
377: AND NOT EXISTS
378: ( /* Check if a locked Amended Payment Summary does not exist for this year */

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

371: AND ppa1.report_qualifier = 'AU'
372: AND ppa1.report_category = 'REPORT'
373: AND paa1.assignment_id = paf.assignment_id
374: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
375: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
376: )
377: AND NOT EXISTS
378: ( /* Check if a locked Amended Payment Summary does not exist for this year */
379: SELECT '1'

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

383: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
384: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
385: AND ppa2.report_qualifier = 'AU'
386: AND ppa2.report_category = 'REPORT'
387: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year
388: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa2.legislative_parameters) = c_tax_unit_id
389: AND paa2.assignment_id = paf.assignment_id
390: AND pai.locked_action_id = paa2.assignment_action_id
391: );

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

384: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
385: AND ppa2.report_qualifier = 'AU'
386: AND ppa2.report_category = 'REPORT'
387: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year
388: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa2.legislative_parameters) = c_tax_unit_id
389: AND paa2.assignment_id = paf.assignment_id
390: AND pai.locked_action_id = paa2.assignment_action_id
391: );
392:

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

419: AND ppa1.report_type = 'AU_PS_DATA_FILE'
420: AND ppa1.report_qualifier = 'AU'
421: AND ppa1.report_category = 'REPORT'
422: AND paa1.assignment_id = paf.assignment_id
423: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
424: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
425: )
426: ;
427:

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

420: AND ppa1.report_qualifier = 'AU'
421: AND ppa1.report_category = 'REPORT'
422: AND paa1.assignment_id = paf.assignment_id
423: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
424: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
425: )
426: ;
427:
428: /* 9113084 - Added range person cursor for the above CURSOR process_assignments */

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

468: pay_assignment_actions paa1
469: WHERE ppa1.report_type = 'AU_PS_DATA_FILE'
470: AND ppa1.report_qualifier = 'AU'
471: AND ppa1.report_category = 'REPORT'
472: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
473: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
474: AND paa1.payroll_action_id = nvl(ppa1.payroll_action_id,ppa.payroll_action_id)
475: AND paa1.assignment_id = has.assignment_id)
476: AND NOT EXISTS (

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

469: WHERE ppa1.report_type = 'AU_PS_DATA_FILE'
470: AND ppa1.report_qualifier = 'AU'
471: AND ppa1.report_category = 'REPORT'
472: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
473: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
474: AND paa1.payroll_action_id = nvl(ppa1.payroll_action_id,ppa.payroll_action_id)
475: AND paa1.assignment_id = has.assignment_id)
476: AND NOT EXISTS (
477: /* Check if a locked Amended Payment Summary does not exist for this year */

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

486: pay_action_interlocks pai
487: WHERE ppa2.report_type = 'AU_PAY_SUMM_AMEND'
488: AND ppa2.report_qualifier = 'AU'
489: AND ppa2.report_category = 'REPORT'
490: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year
491: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa2.legislative_parameters) = c_tax_unit_id
492: AND paa2.payroll_action_id = nvl(ppa2.payroll_action_id,ppa.payroll_action_id)
493: AND paa2.assignment_id = has.assignment_id
494: AND pai.locked_action_id = paa2.assignment_action_id);

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

487: WHERE ppa2.report_type = 'AU_PAY_SUMM_AMEND'
488: AND ppa2.report_qualifier = 'AU'
489: AND ppa2.report_category = 'REPORT'
490: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year
491: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa2.legislative_parameters) = c_tax_unit_id
492: AND paa2.payroll_action_id = nvl(ppa2.payroll_action_id,ppa.payroll_action_id)
493: AND paa2.assignment_id = has.assignment_id
494: AND pai.locked_action_id = paa2.assignment_action_id);
495:

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

535: pay_assignment_actions paa1
536: WHERE ppa1.report_type = 'AU_PS_DATA_FILE'
537: AND ppa1.report_qualifier = 'AU'
538: AND ppa1.report_category = 'REPORT'
539: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
540: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
541: AND paa1.payroll_action_id = nvl(ppa1.payroll_action_id,ppa.payroll_action_id)
542: AND paa1.assignment_id = has.assignment_id)
543: ;

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

536: WHERE ppa1.report_type = 'AU_PS_DATA_FILE'
537: AND ppa1.report_qualifier = 'AU'
538: AND ppa1.report_category = 'REPORT'
539: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year
540: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa1.legislative_parameters) = c_tax_unit_id
541: AND paa1.payroll_action_id = nvl(ppa1.payroll_action_id,ppa.payroll_action_id)
542: AND paa1.assignment_id = has.assignment_id)
543: ;
544:

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

2179: AND mpaa.payroll_action_id = mppa.payroll_action_id
2180: AND mppa.report_type = 'AU_PS_DATA_FILE'
2181: AND mppa.report_qualifier = 'AU'
2182: AND mppa.report_category = 'REPORT'
2183: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',mppa.legislative_parameters) = c_fin_year
2184: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mppa.legislative_parameters) = c_tax_unit_id
2185: AND mplock.locking_action_id = mpaa.assignment_action_id
2186: AND mplock.locked_action_id = selfplock.locking_action_id
2187: ORDER BY selfplock.locked_action_id desc; /* bug 14621185 - picking up the latest archive */

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

2180: AND mppa.report_type = 'AU_PS_DATA_FILE'
2181: AND mppa.report_qualifier = 'AU'
2182: AND mppa.report_category = 'REPORT'
2183: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',mppa.legislative_parameters) = c_fin_year
2184: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mppa.legislative_parameters) = c_tax_unit_id
2185: AND mplock.locking_action_id = mpaa.assignment_action_id
2186: AND mplock.locked_action_id = selfplock.locking_action_id
2187: ORDER BY selfplock.locked_action_id desc; /* bug 14621185 - picking up the latest archive */
2188:

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

2187: ORDER BY selfplock.locked_action_id desc; /* bug 14621185 - picking up the latest archive */
2188:
2189:
2190: CURSOR c_action(c_assignment_action_id NUMBER) IS
2191: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters)
2192: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)
2193: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
2194: , ppa.payroll_action_id
2195: , paa.assignment_id

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

2188:
2189:
2190: CURSOR c_action(c_assignment_action_id NUMBER) IS
2191: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters)
2192: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)
2193: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
2194: , ppa.payroll_action_id
2195: , paa.assignment_id
2196: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')

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

2189:
2190: CURSOR c_action(c_assignment_action_id NUMBER) IS
2191: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters)
2192: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)
2193: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
2194: , ppa.payroll_action_id
2195: , paa.assignment_id
2196: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
2197: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')

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

2192: , pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters)
2193: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
2194: , ppa.payroll_action_id
2195: , paa.assignment_id
2196: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
2197: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
2198: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters)
2199: , pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters)
2200: FROM pay_assignment_actions paa

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

2193: , pay_core_utils.get_parameter('EMPLOYEE_TYPE',ppa.legislative_parameters)
2194: , ppa.payroll_action_id
2195: , paa.assignment_id
2196: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
2197: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
2198: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters)
2199: , pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters)
2200: FROM pay_assignment_actions paa
2201: , pay_payroll_actions ppa

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

2194: , ppa.payroll_action_id
2195: , paa.assignment_id
2196: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
2197: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
2198: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters)
2199: , pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters)
2200: FROM pay_assignment_actions paa
2201: , pay_payroll_actions ppa
2202: WHERE paa.assignment_action_id = c_assignment_action_id

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

2195: , paa.assignment_id
2196: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
2197: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
2198: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters)
2199: , pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters)
2200: FROM pay_assignment_actions paa
2201: , pay_payroll_actions ppa
2202: WHERE paa.assignment_action_id = c_assignment_action_id
2203: AND ppa.payroll_action_id = paa.payroll_action_id ;

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

2456: --------------------------------------------------------------------+
2457:
2458: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2459: IS
2460: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
2461: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
2462: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
2463: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
2464: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,

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

2457:
2458: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2459: IS
2460: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
2461: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
2462: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
2463: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
2464: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
2465: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,

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

2458: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2459: IS
2460: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
2461: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
2462: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
2463: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
2464: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
2465: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
2466: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE

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

2459: IS
2460: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
2461: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
2462: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
2463: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
2464: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
2465: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
2466: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
2467: FROM pay_payroll_actions ppa

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

2460: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
2461: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
2462: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
2463: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
2464: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
2465: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
2466: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
2467: FROM pay_payroll_actions ppa
2468: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

2461: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
2462: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
2463: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
2464: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
2465: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
2466: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
2467: FROM pay_payroll_actions ppa
2468: WHERE ppa.payroll_action_id = c_payroll_action_id;
2469:

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

2462: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,
2463: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
2464: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
2465: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
2466: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
2467: FROM pay_payroll_actions ppa
2468: WHERE ppa.payroll_action_id = c_payroll_action_id;
2469:
2470: