APPS.PAY_CA_T4_REG dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 106: l_prov_cd ff_archive_item_contexts.context%TYPE;

102: lockingactid number;
103: lockedactid number;
104: l_asg_set_id number;
105: l_asg_id number;
106: l_prov_cd ff_archive_item_contexts.context%TYPE;
107: l_province ff_archive_item_contexts.context%TYPE;
108: l_tax_unit_id number;
109: l_year varchar2(4);
110: l_bus_group_id number;

Line 107: l_province ff_archive_item_contexts.context%TYPE;

103: lockedactid number;
104: l_asg_set_id number;
105: l_asg_id number;
106: l_prov_cd ff_archive_item_contexts.context%TYPE;
107: l_province ff_archive_item_contexts.context%TYPE;
108: l_tax_unit_id number;
109: l_year varchar2(4);
110: l_bus_group_id number;
111: l_year_start date;

Line 190: ff_archive_item_contexts faic

186: from per_assignments_f paf,
187: pay_assignment_actions paa,
188: ff_archive_items fai,
189: ff_contexts fc,
190: ff_archive_item_contexts faic
191: where paf.person_id between stperson
192: and endperson
193: and paf.primary_flag = 'Y'
194: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 224: ff_archive_item_contexts faic,

220: from per_assignments_f paf,
221: pay_assignment_actions paa,
222: ff_archive_items fai,
223: ff_contexts fc,
224: ff_archive_item_contexts faic,
225: pay_population_ranges ppr
226: where --paf.person_id between stperson
227: -- and endperson
228: paf.primary_flag = 'Y'

Line 261: ff_archive_item_contexts faic,

257: from per_assignments_f paf,
258: pay_assignment_actions paa,
259: ff_archive_items fai,
260: ff_contexts fc,
261: ff_archive_item_contexts faic,
262: per_periods_of_service PDS
263: where paf.person_id between stperson
264: and endperson
265: and paf.primary_flag = 'Y'

Line 296: ff_archive_item_contexts faic,

292: from per_assignments_f paf,
293: pay_assignment_actions paa,
294: ff_archive_items fai,
295: ff_contexts fc,
296: ff_archive_item_contexts faic,
297: pay_population_ranges ppr,
298: per_periods_of_service PDS
299: where --paf.person_id between stperson
300: -- and endperson

Line 338: ff_archive_item_contexts faic

334: from per_assignments_f paf,
335: pay_assignment_actions paa,
336: ff_archive_items fai,
337: ff_contexts fc,
338: ff_archive_item_contexts faic
339: where paf.person_id between stperson
340: and endperson
341: and paf.primary_flag = 'Y'
342: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 374: ff_archive_item_contexts faic,

370: from per_assignments_f paf,
371: pay_assignment_actions paa,
372: ff_archive_items fai,
373: ff_contexts fc,
374: ff_archive_item_contexts faic,
375: per_periods_of_service PDS
376: where paf.person_id between stperson
377: and endperson
378: and paf.primary_flag = 'Y'

Line 413: ff_archive_item_contexts faic,

409: paf.effective_end_date
410: from per_assignments_f paf,
411: pay_assignment_actions paa,
412: ff_archive_items fai,
413: ff_archive_item_contexts faic,
414: ff_contexts fc
415: where paf.person_id >= stperson
416: and paf.person_id <= endperson
417: and paf.primary_flag = 'Y'

Line 451: ff_archive_item_contexts faic,

447: paf.effective_end_date
448: from per_assignments_f paf,
449: pay_assignment_actions paa,
450: ff_archive_items fai,
451: ff_archive_item_contexts faic,
452: ff_contexts fc,
453: pay_population_ranges ppr
454: where --paf.person_id >= stperson
455: --and paf.person_id <= endperson

Line 492: ff_archive_item_contexts faic,

488: paf.effective_end_date
489: from per_assignments_f paf,
490: pay_assignment_actions paa,
491: ff_archive_items fai,
492: ff_archive_item_contexts faic,
493: ff_contexts fc,
494: per_periods_of_service PDS
495: where paf.person_id >= stperson
496: and paf.person_id <= endperson

Line 532: ff_archive_item_contexts faic,

528: paf.effective_end_date
529: from per_assignments_f paf,
530: pay_assignment_actions paa,
531: ff_archive_items fai,
532: ff_archive_item_contexts faic,
533: ff_contexts fc,
534: pay_population_ranges ppr,
535: per_periods_of_service PDS
536: where --paf.person_id >= stperson