DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 4692: from ff_archive_item_contexts aic,

4688: is
4689: cursor cur_get_pact_archive_items is
4690: select upper(nvl(max(decode(fue.user_entity_name,'X_EMPLOYERS_NAME',fai.VALUE)),null)) EMPLOYERS_NAME,
4691: upper(nvl(max(decode(fue.user_entity_name,'X_EMPLOYERS_ADDRESS_LINE',fai.VALUE)),null)) EMPLOYERS_ADDRESS
4692: from ff_archive_item_contexts aic,
4693: ff_archive_items fai,
4694: ff_user_entities fue
4695: where X_PAYROLL_ACTION_ID = fai.context1
4696: and fai.user_entity_id = fue.user_entity_id