DBA Data[Home] [Help]

APPS.PAY_US_W2C_RPT dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 1591: ff_archive_item_contexts fac,

1587: select fai.value
1588: into lv_ein
1589: from ff_database_items fdi,
1590: ff_archive_items fai,
1591: ff_archive_item_contexts fac,
1592: ff_archive_item_contexts fac1
1593: where fai.user_entity_id = fdi.user_entity_id
1594: and fai.context1 = to_char(ln_eoy_pactid)
1595: and fac.archive_item_id = fai.archive_item_id

Line 1592: ff_archive_item_contexts fac1

1588: into lv_ein
1589: from ff_database_items fdi,
1590: ff_archive_items fai,
1591: ff_archive_item_contexts fac,
1592: ff_archive_item_contexts fac1
1593: where fai.user_entity_id = fdi.user_entity_id
1594: and fai.context1 = to_char(ln_eoy_pactid)
1595: and fac.archive_item_id = fai.archive_item_id
1596: and ltrim(rtrim(fac.context)) = to_char(p_w2c_tax_unit_id)