DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ERROR dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 897: ff_archive_item_contexts fac,

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

Line 898: ff_archive_item_contexts fac1,

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

Line 919: ff_archive_item_contexts fac,

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

Line 940: ff_archive_item_contexts fac,

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