DBA Data[Home] [Help]

APPS.PAY_US_MWR_REPORTING_PKG dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 349: FROM ff_archive_item_contexts con3,

345: p_tax_unit_id number,
346: P_jurisdiction_code varchar2
347: ) IS
348: SELECT fai.value
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

Line 350: ff_archive_item_contexts con2,

346: P_jurisdiction_code varchar2
347: ) IS
348: SELECT fai.value
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

Line 483: FROM ff_archive_item_contexts con3,

479: cp_tax_unit_id number,
480: cp_jurisdiction_code varchar2
481: ) IS
482: SELECT fai.value
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

Line 484: ff_archive_item_contexts con2,

480: cp_jurisdiction_code varchar2
481: ) IS
482: SELECT fai.value
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