DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ERROR dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 830: ff_archive_item_contexts fac,

826: cp_state_code in varchar2) is
827: select fdi.user_name,fai.value
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

Line 831: ff_archive_item_contexts fac1,

827: select fdi.user_name,fai.value
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)

Line 852: ff_archive_item_contexts fac,

848: cp_tax_unit_id in number) is
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 */

Line 873: ff_archive_item_contexts fac,

869: p_asg_id in number) is
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 */