DBA Data[Home] [Help]

APPS.PAY_CA_T4_REG dependencies on FF_CONTEXTS

Line 189: ff_contexts fc,

185: paf.effective_end_date
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'

Line 223: ff_contexts fc,

219: paf.effective_end_date
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

Line 260: ff_contexts fc,

256: paf.effective_end_date
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

Line 295: ff_contexts fc,

291: paf.effective_end_date
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

Line 337: ff_contexts fc,

333: paf.effective_end_date
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'

Line 373: ff_contexts fc,

369: paf.effective_end_date
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

Line 414: ff_contexts fc

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'
418: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 452: ff_contexts fc,

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
456: paf.primary_flag = 'Y'

Line 493: ff_contexts fc,

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
497: and paf.primary_flag = 'Y'

Line 533: ff_contexts fc,

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
537: --and paf.person_id <= endperson