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_PAYROLL_ACTIONS

Line 40: pay_payroll_actions PPA

36: sql_range :=
37: 'SELECT distinct ASG.person_id
38: FROM per_assignments_f ASG,
39: pay_payrolls_f PPY,
40: pay_payroll_actions PPA
41: WHERE PPA.payroll_action_id = :payroll_action_id
42: AND ASG.business_group_id = PPA.business_group_id
43: AND ASG.assignment_type = ''E''
44: AND PPY.payroll_id = ASG.payroll_id

Line 99: , pay_payroll_actions ppa_arch

95: , asg.assignment_id assignment_id
96: FROM
97: per_all_assignments_f asg
98: , pay_all_payrolls_f ppf
99: , pay_payroll_actions ppa_arch
100: WHERE
101: asg.business_group_id + 0 = ppa_arch.business_group_id
102: AND asg.person_id BETWEEN stperson
103: AND endperson

Line 123: , pay_payroll_actions ppa

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
127: AND ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')

Line 138: "in the TYE Archiver SRS - thus, whenever the pay_payroll_actions.payroll_id is used

134: -- and not an indirect result
135: -- Note: The source_id is the Source Element Entry
136: /*
137: "The TYE Archiver Payroll Action is tied to the specific payroll that was given
138: "in the TYE Archiver SRS - thus, whenever the pay_payroll_actions.payroll_id is used
139: "subsequently, it will limit the query to ONLY processing that took place on the
140: "last payroll the assignment was on at TYE - thus, for e.g. cursor lumpsum, in which any
141: "Lump Sums run on the earlier payroll will NOT be found because ppa_arch.payroll_id is used.
142: "

Line 155: pay_payroll_actions ppa,

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
159: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I') -- added for 5165859

Line 165: from pay_payroll_actions ppa_arch

161: And pac.context_value <> 'To Be Advised'
162: and ffc.context_name = 'SOURCE_TEXT'
163: and ffc.context_id = pac.context_id
164: and ppa.effective_date >= (select ppa_arch.start_date
165: from pay_payroll_actions ppa_arch
166: where ppa_arch.payroll_action_id = pay_action_id)
167: and ppa.effective_date <= (select ppa_arch.effective_date
168: from pay_payroll_actions ppa_arch
169: where ppa_arch.payroll_action_id = pay_action_id);

Line 168: from pay_payroll_actions ppa_arch

164: and ppa.effective_date >= (select ppa_arch.start_date
165: from pay_payroll_actions ppa_arch
166: where ppa_arch.payroll_action_id = pay_action_id)
167: and ppa.effective_date <= (select ppa_arch.effective_date
168: from pay_payroll_actions ppa_arch
169: where ppa_arch.payroll_action_id = pay_action_id);
170:
171: asg_set_id number;
172: person_id number;

Line 174: leg_param pay_payroll_actions.legislative_parameters%type;

170:
171: asg_set_id number;
172: person_id number;
173: l_payroll_id number;
174: leg_param pay_payroll_actions.legislative_parameters%type;
175: asg_include boolean;
176: lockingactid number;
177: v_incl_sw char;
178: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;

Line 178: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;

174: leg_param pay_payroll_actions.legislative_parameters%type;
175: asg_include boolean;
176: lockingactid number;
177: v_incl_sw char;
178: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
179:
180: BEGIN
181:
182: -- hr_utility.trace_on(null, 'TYE2005');

Line 187: from pay_payroll_actions

183:
184: -- Get the legislative parameters from the archiver payroll action
185: select legislative_parameters,payroll_id
186: into leg_param,l_ppa_payroll_id
187: from pay_payroll_actions
188: where payroll_action_id = pactid;
189:
190: asg_set_id := get_parameter('ASG_SET_ID', leg_param);
191: person_id := get_parameter('PERSON_ID', leg_param);

Line 197: update pay_payroll_actions

193:
194: -- Update the Payroll Action with the Payroll ID
195: --
196: IF l_ppa_payroll_id IS NULL THEN
197: update pay_payroll_actions
198: set payroll_id = l_payroll_id
199: where payroll_action_id = pactid;
200: END IF;
201:

Line 353: pay_payroll_actions ppa,

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
357: and paa_all.payroll_action_id = ppa.payroll_action_id

Line 381: pay_payroll_actions ppa,

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
385: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I') -- added for 5165859

Line 391: from pay_payroll_actions ppa_arch

387: And pac.context_value <> 'To Be Advised'
388: and ffc.context_name = 'SOURCE_TEXT'
389: and ffc.context_id = pac.context_id
390: and ppa.effective_date >= (select ppa_arch.start_date
391: from pay_payroll_actions ppa_arch
392: where ppa_arch.payroll_action_id = p_pact_id)
393: and ppa.effective_date <= (select ppa_arch.effective_date
394: from pay_payroll_actions ppa_arch
395: where ppa_arch.payroll_action_id = p_pact_id);

Line 394: from pay_payroll_actions ppa_arch

390: and ppa.effective_date >= (select ppa_arch.start_date
391: from pay_payroll_actions ppa_arch
392: where ppa_arch.payroll_action_id = p_pact_id)
393: and ppa.effective_date <= (select ppa_arch.effective_date
394: from pay_payroll_actions ppa_arch
395: where ppa_arch.payroll_action_id = p_pact_id);
396:
397: begin
398: l_main_crt_flag :=0;

Line 413: pay_payroll_actions ppa,

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
417: and ppa.payroll_action_id = aa.payroll_action_id

Line 494: pay_payroll_actions ppa

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')
498: and ppa.effective_date <= p_effective_date;

Line 615: leg_param pay_payroll_actions.legislative_parameters%type;

611: ) is
612: l_req_id NUMBER ;
613: l_start_date DATE;
614: l_end_date DATE;
615: leg_param pay_payroll_actions.legislative_parameters%type;
616: begin
617: select legislative_parameters
618: into leg_param
619: from pay_payroll_actions

Line 619: from pay_payroll_actions

615: leg_param pay_payroll_actions.legislative_parameters%type;
616: begin
617: select legislative_parameters
618: into leg_param
619: from pay_payroll_actions
620: where payroll_action_id = p_payroll_action_id;
621:
622: l_start_date := to_date(get_parameter('START_DATE', leg_param),'YYYY/MM/DD hh24:mi:ss');
623: l_end_date := to_date(get_parameter('END_DATE', leg_param),'YYYY/MM/DD hh24:mi:ss');

Line 663: token_val pay_payroll_actions.legislative_parameters%type;

659: ) return varchar2 is
660:
661: start_ptr number;
662: end_ptr number;
663: token_val pay_payroll_actions.legislative_parameters%type;
664: par_value pay_payroll_actions.legislative_parameters%type;
665:
666: begin
667:

Line 664: par_value pay_payroll_actions.legislative_parameters%type;

660:
661: start_ptr number;
662: end_ptr number;
663: token_val pay_payroll_actions.legislative_parameters%type;
664: par_value pay_payroll_actions.legislative_parameters%type;
665:
666: begin
667:
668: token_val := name || '=';

Line 725: From pay_payroll_actions ppa_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
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 =

Line 773: From pay_payroll_actions ppa_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
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 =

Line 1041: from pay_payroll_actions

1037: -- Check whether this is the first time that THIS Creator is running in this tax year
1038: -- If the answer is yes, then reset the Generation Number to 0
1039: select count(*)
1040: into l_count
1041: from pay_payroll_actions
1042: where action_type = 'X'
1043: and report_type = 'ZA_IRP5'
1044: and business_group_id = to_number(p_bg_id)
1045: and pay_za_irp5_archive_pkg.get_parameter('TAX_YEAR', legislative_parameters) = p_tax_year;

Line 1139: pay_payroll_actions ppa

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'
1143: and substr(ppa.legislative_parameters,

Line 1153: pay_payroll_actions ppa

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'
1157: and substr(ppa.legislative_parameters,