DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on ECE_TP_DETAILS

Line 1941: from ece_tp_details etd,

1937: END IF;
1938:
1939: delete from po_purge_vendor_list pvl
1940: where exists (select null
1941: from ece_tp_details etd,
1942: ap_supplier_sites_all pvs
1943: where etd.tp_header_id = pvs.tp_header_id
1944: and pvs.vendor_id = pvl.vendor_id
1945: and etd.last_update_date > g_activity_date);

Line 4121: from ece_tp_details etd,

4117: update po_purge_vendor_list pvl
4118: set double_check_flag = 'N'
4119: where pvl.double_check_flag = 'Y'
4120: and (exists (select null
4121: from ece_tp_details etd,
4122: ap_supplier_sites_all pvs
4123: where etd.tp_header_id = pvs.tp_header_id
4124: and pvs.vendor_id = pvl.vendor_id
4125: and etd.last_update_date > g_activity_date));