DBA Data[Home] [Help]

APPS.PAY_US_PSD_GENERIC_EXTRACT dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 689: from ff_archive_item_contexts faic,

685: AS
686:
687: CURSOR c_get_psd_data(psd_ue_name varchar2) IS
688: select fai.value
689: from ff_archive_item_contexts faic,
690: ff_contexts fc,
691: ff_archive_items fai,
692: ff_database_items fdi,
693: ff_contexts fc2,

Line 694: ff_archive_item_contexts faic2

690: ff_contexts fc,
691: ff_archive_items fai,
692: ff_database_items fdi,
693: ff_contexts fc2,
694: ff_archive_item_contexts faic2
695: where fdi.user_name = psd_ue_name
696: and fdi.user_entity_id = fai.user_entity_id
697: and fai.context1 = p_payroll_action_id
698: and fc.context_name = 'TAX_UNIT_ID'