DBA Data[Home] [Help]

APPS.PAY_US_MWR_REPORTING_PKG dependencies on FF_CONTEXTS

Line 351: ff_contexts fc3,

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
355: and fai.context1 = to_char(p_ass_act_id)

Line 352: ff_contexts fc2,

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
355: and fai.context1 = to_char(p_ass_act_id)
356: /* context assignment action id */

Line 485: ff_contexts fc3,

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
489: and fai.context1 = to_char(cp_ass_act_id)

Line 486: ff_contexts fc2,

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
489: and fai.context1 = to_char(cp_ass_act_id)
490: /* context assignment action id */