DBA Data[Home] [Help]

APPS.PAY_US_MWR_REPORTING_PKG dependencies on FF_ARCHIVE_ITEMS

Line 317: FROM ff_archive_items fai

313: ,p_mon_of_qtr number) IS
314: SELECT fai.value,
315: pus.state_code || '-000-0000',
316: pus.state_abbrev
317: FROM ff_archive_items fai
318: ,ff_user_entities ue
319: ,pay_us_states pus
320: ,hr_locations hl
321: where fai.user_entity_id = ue.user_entity_id

Line 353: ff_archive_items fai

349: FROM ff_archive_item_contexts con3,
350: ff_archive_item_contexts con2,
351: ff_contexts fc3,
352: ff_contexts fc2,
353: ff_archive_items fai
354: WHERE fai.user_entity_id = p_user_entity_id
355: and fai.context1 = to_char(p_ass_act_id)
356: /* context assignment action id */
357: and fc2.context_name = 'TAX_UNIT_ID'

Line 438: from ff_archive_items fai,

434: IS
435:
436: select fai.value,
437: ppa.report_qualifier
438: from ff_archive_items fai,
439: ff_user_entities ue,
440: pay_assignment_actions paa,
441: pay_payroll_actions ppa
442: where fai.context1 = cp_sqwl_assact

Line 487: ff_archive_items fai

483: FROM ff_archive_item_contexts con3,
484: ff_archive_item_contexts con2,
485: ff_contexts fc3,
486: ff_contexts fc2,
487: ff_archive_items fai
488: WHERE fai.user_entity_id = cp_user_entity_id
489: and fai.context1 = to_char(cp_ass_act_id)
490: /* context assignment action id */
491: and fc2.context_name = 'TAX_UNIT_ID'