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_ZA_IRP5_ARCHIVE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 122: FROM pay_assignment_actions paa

118: AND ppa_arch.payroll_action_id = pactid
119: AND EXISTS (SELECT /*+ ORDERED */
120: /* the ordered hint will force the paa table to be joined to first */
121: NULL
122: FROM pay_assignment_actions paa
123: , pay_payroll_actions ppa
124: WHERE paa.assignment_id = asg.assignment_id
125: AND ppa.effective_date BETWEEN ppa_arch.start_date
126: AND ppa_arch.effective_date

Line 154: pay_assignment_actions paa,

150: --for the Payroll as at Tax Year End anymore.
151: cursor lumpsum (pay_action_id number, asg_id number) is
152: select distinct pac.context_value
153: from pay_action_contexts pac,
154: pay_assignment_actions paa,
155: pay_payroll_actions ppa,
156: ff_contexts ffc
157: where paa.assignment_id = asg_id
158: and paa.payroll_action_id = ppa.payroll_action_id

Line 264: select pay_assignment_actions_s.nextval

260: for lumprec in lumpsum(pactid, asgrec.assignment_id) loop
261:
262: hr_utility.set_location('LUMP SUM:' || to_char(asgrec.assignment_id),10);
263:
264: select pay_assignment_actions_s.nextval
265: into lockingactid
266: from dual;
267: hr_utility.set_location('lockingactidM:' || lockingactid,10);
268: -- Insert Lump Sums into pay_assignment_actions

Line 268: -- Insert Lump Sums into pay_assignment_actions

264: select pay_assignment_actions_s.nextval
265: into lockingactid
266: from dual;
267: hr_utility.set_location('lockingactidM:' || lockingactid,10);
268: -- Insert Lump Sums into pay_assignment_actions
269: hr_nonrun_asact.insact
270: (
271: lockingactid => lockingactid,
272: assignid => asgrec.assignment_id,

Line 282: select pay_assignment_actions_s.nextval

278:
279: end loop;
280: -- For Normal
281:
282: select pay_assignment_actions_s.nextval
283: into lockingactid
284: from dual;
285:
286: -- Insert assignment into pay_assignment_actions

Line 286: -- Insert assignment into pay_assignment_actions

282: select pay_assignment_actions_s.nextval
283: into lockingactid
284: from dual;
285:
286: -- Insert assignment into pay_assignment_actions
287: hr_nonrun_asact.insact
288: (
289: lockingactid,
290: asgrec.assignment_id,

Line 319: asgid pay_assignment_actions.assignment_id%type;

315: p_assactid in number,
316: p_effective_date in date
317: ) is
318:
319: asgid pay_assignment_actions.assignment_id%type;
320: l_count number;
321: l_flag number;
322: l_context_no number;
323: aaseq number;

Line 351: pay_assignment_actions paa,

347: AND fcon.context_name ='SOURCE_NUMBER'
348: And PAC.ASSIGNMENT_ACTION_ID in
349: (
350: Select paa_all.assignment_Action_id from
351: pay_assignment_actions paa,
352: pay_assignment_actions paa_all,
353: pay_payroll_actions ppa,
354: per_time_periods ptp
355: Where paa.assignment_action_id = p_assignment_Action_id

Line 352: pay_assignment_actions paa_all,

348: And PAC.ASSIGNMENT_ACTION_ID in
349: (
350: Select paa_all.assignment_Action_id from
351: pay_assignment_actions paa,
352: pay_assignment_actions paa_all,
353: pay_payroll_actions ppa,
354: per_time_periods ptp
355: Where paa.assignment_action_id = p_assignment_Action_id
356: and paa_all.assignment_id = paa.assignment_id

Line 380: pay_assignment_actions paa,

376:
377: CURSOR curdirnum (p_ass_id IN NUMBER ,p_pact_id IN number) is
378: SELECT DISTINCT pac.context_value directive_number
379: from pay_action_contexts pac,
380: pay_assignment_actions paa,
381: pay_payroll_actions ppa,
382: ff_contexts ffc
383: where paa.assignment_id = p_ass_id
384: and paa.payroll_action_id = ppa.payroll_action_id

Line 412: from pay_assignment_actions aa,

408: paf.payroll_id,
409: ppa.effective_date,
410: ppa.payroll_action_id
411: into asgid, l_payroll_id, l_eff_date, l_pact_id
412: from pay_assignment_actions aa,
413: pay_payroll_actions ppa,
414: per_assignments_f paf
415: where aa.assignment_action_id = p_assactid
416: and aa.assignment_id = paf.assignment_id

Line 476: in the table pay_assignment_actions during action_creation which will be used here

472: "Lump Sum processing that took place on earlier payrolls for this assignment
473: */
474: /*
475: As part of Lump Sum Enhancement the Assignment_action_id is stored
476: in the table pay_assignment_actions during action_creation which will be used here
477: */
478: Select count(*)
479: into l_main_crt_flag
480: From pay_assignment_actions paa_arch

Line 480: From pay_assignment_actions paa_arch

476: in the table pay_assignment_actions during action_creation which will be used here
477: */
478: Select count(*)
479: into l_main_crt_flag
480: From pay_assignment_actions paa_arch
481: Where paa_arch.assignment_action_id > p_assactid
482: AND paa_arch.payroll_action_id = l_pact_id
483: AND paa_arch.assignment_id = asgid;
484:

Line 493: from pay_assignment_actions paa,

489: -- printing the Lump Sum Certificates before the Main Certificate
490:
491: select max(paa.action_sequence)
492: into aaseq
493: from pay_assignment_actions paa,
494: pay_payroll_actions ppa
495: where paa.assignment_id = asgid
496: and paa.payroll_action_id = ppa.payroll_action_id
497: and ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')

Line 504: from pay_assignment_actions

500:
501:
502: select assignment_action_id, payroll_action_id
503: into aaid, paid
504: from pay_assignment_actions
505: where assignment_id = asgid
506: and action_sequence = aaseq;
507:
508: -- Assignment Action ID of a max(action_sequence) Payroll Run

Line 720: From pay_assignment_actions paa_arch

716:
717: -- Get and cache the Lump Sum Indicator
718: /* Select decode(count(source_action_id),0,'N','Y')
719: into g_ls_indicator
720: From pay_assignment_actions paa_arch
721: Where paa_arch.assignment_action_id = pay_archive.archive_aa;*/
722:
723: Select decode(count(*), 0 ,'Y', 'N')
724: into g_ls_indicator

Line 726: pay_assignment_actions paa_arch

722:
723: Select decode(count(*), 0 ,'Y', 'N')
724: into g_ls_indicator
725: From pay_payroll_actions ppa_arch,
726: pay_assignment_actions paa_arch
727: where paa_arch.assignment_action_id = pay_archive.archive_aa
728: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
729: and paa_arch.assignment_action_id =
730: (

Line 732: from pay_assignment_actions paa

728: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
729: and paa_arch.assignment_action_id =
730: (
731: select max(paa.assignment_action_id)
732: from pay_assignment_actions paa
733: where paa.payroll_action_id = ppa_arch.payroll_action_id
734: and paa.assignment_id = paa_arch.assignment_id
735: ) ;
736:

Line 768: From pay_assignment_actions paa_arch

764:
765: -- Get and cache the Lump Sum Indicator
766: /* Select decode(count(source_action_id),0,'N','Y')
767: into g_ls_indicator
768: From pay_assignment_actions paa_arch
769: Where paa_arch.assignment_action_id = pay_archive.archive_aa;*/
770:
771: Select decode(count(*), 0 ,'Y', 'N')
772: into g_ls_indicator

Line 774: pay_assignment_actions paa_arch

770:
771: Select decode(count(*), 0 ,'Y', 'N')
772: into g_ls_indicator
773: From pay_payroll_actions ppa_arch,
774: pay_assignment_actions paa_arch
775: where paa_arch.assignment_action_id = pay_archive.archive_aa
776: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
777: and paa_arch.assignment_action_id =
778: (

Line 780: from pay_assignment_actions paa

776: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
777: and paa_arch.assignment_action_id =
778: (
779: select max(paa.assignment_action_id)
780: from pay_assignment_actions paa
781: where paa.payroll_action_id = ppa_arch.payroll_action_id
782: and paa.assignment_id = paa_arch.assignment_id
783: ) ;
784:

Line 1138: from pay_assignment_actions paa,

1134:
1135: -- Get the current largest number
1136: select max(substr(paa.serial_number, 5, 6))
1137: into max_num
1138: from pay_assignment_actions paa,
1139: pay_payroll_actions ppa
1140: where ppa.business_group_id = p_bg
1141: and ppa.report_type = 'ZA_IRP5'
1142: and ppa.action_type = 'X'

Line 1152: from pay_assignment_actions paa,

1148: and substr(paa.serial_number, 1, 2) = '&&';
1149:
1150: select max(substr(paa.serial_number, 3, 6))
1151: into l_max_num
1152: from pay_assignment_actions paa,
1153: pay_payroll_actions ppa
1154: where ppa.business_group_id = p_bg
1155: and ppa.report_type = 'ZA_IRP5'
1156: and ppa.action_type = 'X'