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_PAYROLL_ACTIONS

Line 75: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

71: --------------------------------------------------------------------
72: */
73:
74: PROCEDURE range_code
75: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
76: p_sql OUT NOCOPY VARCHAR2)
77: IS
78: BEGIN
79:

Line 89: ' pay_payroll_actions pa' ||

85: END IF;
86:
87: p_sql := ' select distinct p.person_id' ||
88: ' from per_people_f p,' ||
89: ' pay_payroll_actions pa' ||
90: ' where pa.payroll_action_id = :payroll_action_id' ||
91: ' and p.business_group_id = pa.business_group_id' ||
92: ' order by p.person_id';
93:

Line 176: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)

172: --------------------------------------------------------------------
173: */
174:
175: PROCEDURE initialization_code
176: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)
177: IS
178:
179: l_procedure VARCHAR2(80);
180:

Line 222: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

218: --------------------------------------------------------------------
219: */
220:
221: PROCEDURE assignment_action_code
222: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
223: p_start_person_id IN per_all_people_f.person_id%TYPE,
224: p_end_person_id IN per_all_people_f.person_id%TYPE,
225: p_chunk IN NUMBER)
226: IS

Line 265: FROM pay_payroll_actions

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
269: ,c_start_person_id IN per_all_people_f.person_id%TYPE

Line 268: CURSOR process_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

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
269: ,c_start_person_id IN per_all_people_f.person_id%TYPE
270: ,c_end_person_id IN per_all_people_f.person_id%TYPE
271: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
272: ,c_financial_year IN VARCHAR2

Line 278: ,pay_payroll_actions ppa

274: IS
275: SELECT DISTINCT paf.assignment_id
276: FROM per_assignments_f paf
277: ,per_people_f ppf
278: ,pay_payroll_actions ppa
279: WHERE ppa.payroll_action_id = c_payroll_action_id
280: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id
281: AND ppf.person_id = paf.person_id
282: AND paf.assignment_id = c_assignment_id

Line 287: FROM pay_payroll_actions ppa1

283: AND paf.business_group_id = ppa.business_group_id
284: AND EXISTS
285: ( /* Check if a Datafile is run for this year */
286: SELECT '1'
287: FROM pay_payroll_actions ppa1
288: ,pay_assignment_actions paa1
289: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
290: AND ppa1.report_type = 'AU_PS_DATA_FILE'
291: AND ppa1.report_qualifier = 'AU'

Line 300: FROM pay_payroll_actions ppa2

296: )
297: AND NOT EXISTS
298: ( /* Check if a locked Amended Payment Summary does not exist for this year */
299: SELECT '1'
300: FROM pay_payroll_actions ppa2
301: ,pay_assignment_actions paa2
302: ,pay_action_interlocks pai
303: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
304: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'

Line 314: CURSOR multi_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

310: AND pai.locked_action_id = paa2.assignment_action_id
311: );
312:
313: /* 14621185 - new cursor for multiple amended without checking the previous AU_PAY_SUMM_AMEND */
314: CURSOR multi_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
315: ,c_start_person_id IN per_all_people_f.person_id%TYPE
316: ,c_end_person_id IN per_all_people_f.person_id%TYPE
317: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
318: ,c_financial_year IN VARCHAR2

Line 324: ,pay_payroll_actions ppa

320: IS
321: SELECT DISTINCT paf.assignment_id
322: FROM per_assignments_f paf
323: ,per_people_f ppf
324: ,pay_payroll_actions ppa
325: WHERE ppa.payroll_action_id = c_payroll_action_id
326: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id
327: AND ppf.person_id = paf.person_id
328: AND paf.assignment_id = c_assignment_id

Line 333: FROM pay_payroll_actions ppa1

329: AND paf.business_group_id = ppa.business_group_id
330: AND EXISTS
331: ( /* Check if a Datafile is run for this year */
332: SELECT '1'
333: FROM pay_payroll_actions ppa1
334: ,pay_assignment_actions paa1
335: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
336: AND ppa1.report_type = 'AU_PS_DATA_FILE'
337: AND ppa1.report_qualifier = 'AU'

Line 345: CURSOR process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

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
346: ,c_start_person_id IN per_all_people_f.person_id%TYPE
347: ,c_end_person_id IN per_all_people_f.person_id%TYPE
348: ,c_assignment_set_id IN NUMBER
349: ,c_financial_year IN VARCHAR2

Line 355: ,pay_payroll_actions ppa

351: IS
352: SELECT DISTINCT paf.assignment_id
353: FROM per_assignments_f paf
354: ,per_people_f ppf
355: ,pay_payroll_actions ppa
356: ,hr_assignment_set_amendments has
357: WHERE ppa.payroll_action_id = c_payroll_action_id
358: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id
359: AND ppf.person_id = paf.person_id

Line 367: FROM pay_payroll_actions ppa1

363: AND paf.business_group_id = ppa.business_group_id
364: AND EXISTS
365: ( /* Check if a Datafile is run for this year */
366: SELECT '1'
367: FROM pay_payroll_actions ppa1
368: ,pay_assignment_actions paa1
369: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
370: AND ppa1.report_type = 'AU_PS_DATA_FILE'
371: AND ppa1.report_qualifier = 'AU'

Line 380: FROM pay_payroll_actions ppa2

376: )
377: AND NOT EXISTS
378: ( /* Check if a locked Amended Payment Summary does not exist for this year */
379: SELECT '1'
380: FROM pay_payroll_actions ppa2
381: ,pay_assignment_actions paa2
382: ,pay_action_interlocks pai
383: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
384: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'

Line 394: CURSOR multi_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

390: AND pai.locked_action_id = paa2.assignment_action_id
391: );
392:
393: /* 14621185 - new cursor for multiple amended without checking the previous AU_PAY_SUMM_AMEND */
394: CURSOR multi_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
395: ,c_start_person_id IN per_all_people_f.person_id%TYPE
396: ,c_end_person_id IN per_all_people_f.person_id%TYPE
397: ,c_assignment_set_id IN NUMBER
398: ,c_financial_year IN VARCHAR2

Line 404: ,pay_payroll_actions ppa

400: IS
401: SELECT DISTINCT paf.assignment_id
402: FROM per_assignments_f paf
403: ,per_people_f ppf
404: ,pay_payroll_actions ppa
405: ,hr_assignment_set_amendments has
406: WHERE ppa.payroll_action_id = c_payroll_action_id
407: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id
408: AND ppf.person_id = paf.person_id

Line 416: FROM pay_payroll_actions ppa1

412: AND paf.business_group_id = ppa.business_group_id
413: AND EXISTS
414: ( /* Check if a Datafile is run for this year */
415: SELECT '1'
416: FROM pay_payroll_actions ppa1
417: ,pay_assignment_actions paa1
418: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
419: AND ppa1.report_type = 'AU_PS_DATA_FILE'
420: AND ppa1.report_qualifier = 'AU'

Line 430: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

426: ;
427:
428: /* 9113084 - Added range person cursor for the above CURSOR process_assignments */
429: /* 9113084 - Cursor fetches the assignments for Amended Payment Summary Archive when RANGE_PERSON_ID is enabled */
430: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
431: , c_chunk IN NUMBER
432: ,c_assignment_set_id IN NUMBER
433: ,c_financial_year IN VARCHAR2
434: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

Line 438: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)

434: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
435: IS
436: SELECT /*+ ORDERED
437: USE_NL(PPA, PPR, PAF, HAS)
438: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
439: INDEX(PPR PAY_POPULATION_RANGES_N4)
440: INDEX(PAF PER_ASSIGNMENTS_F_N12)
441: INDEX(HAS HR_ASSIGNMENT_SET_AMENDMEN_PK) */
442: paf.assignment_id

Line 443: FROM pay_payroll_actions ppa,

439: INDEX(PPR PAY_POPULATION_RANGES_N4)
440: INDEX(PAF PER_ASSIGNMENTS_F_N12)
441: INDEX(HAS HR_ASSIGNMENT_SET_AMENDMEN_PK) */
442: paf.assignment_id
443: FROM pay_payroll_actions ppa,
444: pay_population_ranges ppr,
445: per_assignments_f paf,
446: hr_assignment_set_amendments has
447: WHERE ppa.payroll_action_id = c_payroll_action_id

Line 464: INDEX(PPA1 PAY_PAYROLL_ACTIONS_N52)

460: AND EXISTS (
461: /* Check if a Datafile is run for this year */
462: SELECT /*+ ORDERED
463: USE_NL(PPA1, PAA1)
464: INDEX(PPA1 PAY_PAYROLL_ACTIONS_N52)
465: INDEX(PAA1 PAY_ASSIGNMENT_ACTIONS_N51) */
466: '1'
467: FROM pay_payroll_actions ppa1,
468: pay_assignment_actions paa1

Line 467: FROM pay_payroll_actions ppa1,

463: USE_NL(PPA1, PAA1)
464: INDEX(PPA1 PAY_PAYROLL_ACTIONS_N52)
465: INDEX(PAA1 PAY_ASSIGNMENT_ACTIONS_N51) */
466: '1'
467: FROM pay_payroll_actions ppa1,
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'

Line 480: INDEX(PPA2 PAY_PAYROLL_ACTIONS_N52)

476: AND NOT EXISTS (
477: /* Check if a locked Amended Payment Summary does not exist for this year */
478: SELECT /*+ ORDERED
479: USE_NL(PPA2, PAA2, PAI)
480: INDEX(PPA2 PAY_PAYROLL_ACTIONS_N52)
481: INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_N51)
482: INDEX(PAI PAY_ACTION_INTERLOCKS_FK2) */
483: '1'
484: FROM pay_payroll_actions ppa2,

Line 484: FROM pay_payroll_actions ppa2,

480: INDEX(PPA2 PAY_PAYROLL_ACTIONS_N52)
481: INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_N51)
482: INDEX(PAI PAY_ACTION_INTERLOCKS_FK2) */
483: '1'
484: FROM pay_payroll_actions ppa2,
485: pay_assignment_actions paa2,
486: pay_action_interlocks pai
487: WHERE ppa2.report_type = 'AU_PAY_SUMM_AMEND'
488: AND ppa2.report_qualifier = 'AU'

Line 497: CURSOR multi_range_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

493: AND paa2.assignment_id = has.assignment_id
494: AND pai.locked_action_id = paa2.assignment_action_id);
495:
496: /* 14621185 - new cursor for multiple amended without checking the previous AU_PAY_SUMM_AMEND */
497: CURSOR multi_range_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
498: , c_chunk IN NUMBER
499: ,c_assignment_set_id IN NUMBER
500: ,c_financial_year IN VARCHAR2
501: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

Line 505: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)

501: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
502: IS
503: SELECT /*+ ORDERED
504: USE_NL(PPA, PPR, PAF, HAS)
505: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
506: INDEX(PPR PAY_POPULATION_RANGES_N4)
507: INDEX(PAF PER_ASSIGNMENTS_F_N12)
508: INDEX(HAS HR_ASSIGNMENT_SET_AMENDMEN_PK) */
509: paf.assignment_id

Line 510: FROM pay_payroll_actions ppa,

506: INDEX(PPR PAY_POPULATION_RANGES_N4)
507: INDEX(PAF PER_ASSIGNMENTS_F_N12)
508: INDEX(HAS HR_ASSIGNMENT_SET_AMENDMEN_PK) */
509: paf.assignment_id
510: FROM pay_payroll_actions ppa,
511: pay_population_ranges ppr,
512: per_assignments_f paf,
513: hr_assignment_set_amendments has
514: WHERE ppa.payroll_action_id = c_payroll_action_id

Line 531: INDEX(PPA1 PAY_PAYROLL_ACTIONS_N52)

527: AND EXISTS (
528: /* Check if a Datafile is run for this year */
529: SELECT /*+ ORDERED
530: USE_NL(PPA1, PAA1)
531: INDEX(PPA1 PAY_PAYROLL_ACTIONS_N52)
532: INDEX(PAA1 PAY_ASSIGNMENT_ACTIONS_N51) */
533: '1'
534: FROM pay_payroll_actions ppa1,
535: pay_assignment_actions paa1

Line 534: FROM pay_payroll_actions ppa1,

530: USE_NL(PPA1, PAA1)
531: INDEX(PPA1 PAY_PAYROLL_ACTIONS_N52)
532: INDEX(PAA1 PAY_ASSIGNMENT_ACTIONS_N51) */
533: '1'
534: FROM pay_payroll_actions ppa1,
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'

Line 2175: ,pay_payroll_actions mppa

2171: )
2172: IS
2173: SELECT selfplock.locked_action_id
2174: FROM pay_assignment_actions mpaa
2175: ,pay_payroll_actions mppa
2176: ,pay_action_interlocks mplock
2177: ,pay_action_interlocks selfplock
2178: WHERE mpaa.assignment_id = c_assignmenr_id
2179: AND mpaa.payroll_action_id = mppa.payroll_action_id

Line 2201: , pay_payroll_actions ppa

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 ;
2204:
2205: CURSOR get_context_id(c_context_name ff_contexts.context_name%TYPE)

Line 2232: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;

2228: ,'X_FW1_PAYMENT_SUMMARY_TYPE' /*bug9147430*/
2229: ,'X_FW2_PAYMENT_SUMMARY_TYPE'); /*bug9147430*/
2230:
2231: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
2232: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
2233: l_registered_employer hr_organization_units.organization_id%TYPE;
2234: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
2235: l_year_start pay_payroll_Actions.effective_date%TYPE;
2236: l_year_end pay_payroll_actions.effective_date%TYPE;

Line 2234: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;

2230:
2231: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
2232: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
2233: l_registered_employer hr_organization_units.organization_id%TYPE;
2234: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
2235: l_year_start pay_payroll_Actions.effective_date%TYPE;
2236: l_year_end pay_payroll_actions.effective_date%TYPE;
2237: l_employee_type per_all_people_f.current_Employee_Flag%TYPE;
2238: l_lst_yr_term varchar2(10);

Line 2235: l_year_start pay_payroll_Actions.effective_date%TYPE;

2231: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
2232: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
2233: l_registered_employer hr_organization_units.organization_id%TYPE;
2234: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
2235: l_year_start pay_payroll_Actions.effective_date%TYPE;
2236: l_year_end pay_payroll_actions.effective_date%TYPE;
2237: l_employee_type per_all_people_f.current_Employee_Flag%TYPE;
2238: l_lst_yr_term varchar2(10);
2239: l_fin_year VARCHAR2(20);

Line 2236: l_year_end pay_payroll_actions.effective_date%TYPE;

2232: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
2233: l_registered_employer hr_organization_units.organization_id%TYPE;
2234: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
2235: l_year_start pay_payroll_Actions.effective_date%TYPE;
2236: l_year_end pay_payroll_actions.effective_date%TYPE;
2237: l_employee_type per_all_people_f.current_Employee_Flag%TYPE;
2238: l_lst_yr_term varchar2(10);
2239: l_fin_year VARCHAR2(20);
2240: l_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 2437: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)

2433:
2434: END modify_and_archive_code;
2435:
2436: PROCEDURE spawn_data_file
2437: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)
2438: IS
2439:
2440: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2441: l_business_group_id NUMBER;

Line 2440: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

2436: PROCEDURE spawn_data_file
2437: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)
2438: IS
2439:
2440: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2441: l_business_group_id NUMBER;
2442: l_start_date DATE;
2443: l_end_date DATE;
2444: l_effective_date DATE;

Line 2458: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

2454: -- Description : Fetches User Parameters from Legislative_paramters
2455: -- column.
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,

Line 2467: FROM pay_payroll_actions ppa

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:
2471: CURSOR csr_lookup_code (c_financial_year VARCHAR2)