APPS.PAY_US_MWR_REPORTING_PKG dependencies on FF_ARCHIVE_ITEMS

Line 335: FROM ff_archive_items fai

331: ,p_mon_of_qtr number) IS
332: SELECT fai.value,
333: pus.state_code || '-000-0000',
334: pus.state_abbrev
335: FROM ff_archive_items fai
336: ,ff_user_entities ue
337: ,pay_us_states pus
338: ,hr_locations hl
339: where hl.location_id = fai.value

Line 371: ff_archive_items fai

367: FROM ff_archive_item_contexts con3,
368: ff_archive_item_contexts con2,
369: ff_contexts fc3,
370: ff_contexts fc2,
371: ff_archive_items fai
372: WHERE fai.user_entity_id = p_user_entity_id
373: and fai.context1 = to_char(p_ass_act_id)
374: /* context assignment action id */
375: and fc2.context_name = 'TAX_UNIT_ID'

Line 456: from ff_archive_items fai,

452: IS
453:
454: select fai.value,
455: ppa.report_qualifier
456: from ff_archive_items fai,
457: ff_user_entities ue,
458: pay_assignment_actions paa,
459: pay_payroll_actions ppa
460: where fai.context1 = cp_sqwl_assact

Line 514: ff_archive_items fai

510: FROM ff_archive_item_contexts con3,
511: ff_archive_item_contexts con2,
512: ff_contexts fc3,
513: ff_contexts fc2,
514: ff_archive_items fai
515: WHERE fai.user_entity_id = cp_user_entity_id
516: and fai.context1 = to_char(cp_ass_act_id)
517: /* context assignment action id */
518: and fc2.context_name = 'TAX_UNIT_ID'