DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ERROR dependencies on FF_ARCHIVE_ITEMS

Line 896: ff_archive_items fai,

892: cp_tax_unit_id in number,
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

Line 918: ff_archive_items fai,

914: cursor c_archive_dtls_fed(cp_asg_act_id in number,
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)

Line 939: ff_archive_items fai,

935: cursor c_get_asg_details(p_asg_action_id in number,
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)