DBA Data[Home] [Help]

APPS.PAY_US_MWR_REPORTING_PKG dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 367: FROM ff_archive_item_contexts con3,

363: p_tax_unit_id number,
364: P_jurisdiction_code varchar2
365: ) IS
366: SELECT fai.value
367: FROM ff_archive_item_contexts con3,
368: ff_archive_item_contexts con2,
369: ff_contexts fc3,
370: ff_contexts fc2,
371: ff_archive_items fai

Line 368: ff_archive_item_contexts con2,

364: P_jurisdiction_code varchar2
365: ) IS
366: SELECT fai.value
367: FROM ff_archive_item_contexts con3,
368: ff_archive_item_contexts con2,
369: ff_contexts fc3,
370: ff_contexts fc2,
371: ff_archive_items fai
372: WHERE fai.user_entity_id = p_user_entity_id

Line 510: FROM ff_archive_item_contexts con3,

506: cp_tax_unit_id number,
507: cp_jurisdiction_code varchar2
508: ) IS
509: SELECT fai.value
510: FROM ff_archive_item_contexts con3,
511: ff_archive_item_contexts con2,
512: ff_contexts fc3,
513: ff_contexts fc2,
514: ff_archive_items fai

Line 511: ff_archive_item_contexts con2,

507: cp_jurisdiction_code varchar2
508: ) IS
509: SELECT fai.value
510: FROM ff_archive_item_contexts con3,
511: ff_archive_item_contexts con2,
512: ff_contexts fc3,
513: ff_contexts fc2,
514: ff_archive_items fai
515: WHERE fai.user_entity_id = cp_user_entity_id