DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 3886: from ff_archive_item_contexts aic,

3882: is
3883: cursor cur_get_pact_archive_items is
3884: select upper(nvl(max(decode(fue.user_entity_name,'X_EMPLOYERS_NAME',fai.VALUE)),null)) EMPLOYERS_NAME,
3885: upper(nvl(max(decode(fue.user_entity_name,'X_EMPLOYERS_ADDRESS_LINE',fai.VALUE)),null)) EMPLOYERS_ADDRESS
3886: from ff_archive_item_contexts aic,
3887: ff_archive_items fai,
3888: ff_user_entities fue
3889: where X_PAYROLL_ACTION_ID = fai.context1
3890: and fai.user_entity_id = fue.user_entity_id