DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ERROR dependencies on FF_ARCHIVE_ITEMS

Line 829: ff_archive_items fai,

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

Line 851: ff_archive_items fai,

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

Line 872: ff_archive_items fai,

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