DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ERROR dependencies on FF_CONTEXTS

Line 899: ff_contexts fc,

895: from ff_database_items fdi,
896: ff_archive_items fai,
897: ff_archive_item_contexts fac,
898: ff_archive_item_contexts fac1,
899: ff_contexts fc,
900: ff_contexts fc1
901: where fai.user_entity_id = fdi.user_entity_id
902: and fai.context1 = to_char(cp_asg_act_id)
903: /* context assignment action id */

Line 900: ff_contexts fc1

896: ff_archive_items fai,
897: ff_archive_item_contexts fac,
898: ff_archive_item_contexts fac1,
899: ff_contexts fc,
900: ff_contexts fc1
901: where fai.user_entity_id = fdi.user_entity_id
902: and fai.context1 = to_char(cp_asg_act_id)
903: /* context assignment action id */
904: and fac.archive_item_id = fai.archive_item_id

Line 920: ff_contexts fc

916: select fdi.user_name,fai.value
917: from ff_database_items fdi,
918: ff_archive_items fai,
919: ff_archive_item_contexts fac,
920: ff_contexts fc
921: where fai.user_entity_id = fdi.user_entity_id
922: and fai.context1 = to_char(cp_asg_act_id)
923: /* context assignment action id */
924: and fc.context_name = 'TAX_UNIT_ID'

Line 941: ff_contexts fc

937: select fdi.user_name,fai.value
938: from ff_database_items fdi,
939: ff_archive_items fai,
940: ff_archive_item_contexts fac,
941: ff_contexts fc
942: where fai.user_entity_id = fdi.user_entity_id
943: and fai.context1 = to_char(p_asg_action_id)
944: /* context assignment action id */
945: and fc.context_name = 'ASSIGNMENT_ID'