DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ERROR dependencies on FF_CONTEXTS

Line 832: ff_contexts fc,

828: from ff_database_items fdi,
829: ff_archive_items fai,
830: ff_archive_item_contexts fac,
831: ff_archive_item_contexts fac1,
832: ff_contexts fc,
833: ff_contexts fc1
834: where fai.user_entity_id = fdi.user_entity_id
835: and fai.context1 = to_char(cp_asg_act_id)
836: /* context assignment action id */

Line 833: ff_contexts fc1

829: ff_archive_items fai,
830: ff_archive_item_contexts fac,
831: ff_archive_item_contexts fac1,
832: ff_contexts fc,
833: ff_contexts fc1
834: where fai.user_entity_id = fdi.user_entity_id
835: and fai.context1 = to_char(cp_asg_act_id)
836: /* context assignment action id */
837: and fac.archive_item_id = fai.archive_item_id

Line 853: ff_contexts fc

849: select fdi.user_name,fai.value
850: from ff_database_items fdi,
851: ff_archive_items fai,
852: ff_archive_item_contexts fac,
853: ff_contexts fc
854: where fai.user_entity_id = fdi.user_entity_id
855: and fai.context1 = to_char(cp_asg_act_id)
856: /* context assignment action id */
857: and fc.context_name = 'TAX_UNIT_ID'

Line 874: ff_contexts fc

870: select fdi.user_name,fai.value
871: from ff_database_items fdi,
872: ff_archive_items fai,
873: ff_archive_item_contexts fac,
874: ff_contexts fc
875: where fai.user_entity_id = fdi.user_entity_id
876: and fai.context1 = to_char(p_asg_action_id)
877: /* context assignment action id */
878: and fc.context_name = 'ASSIGNMENT_ID'