DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on ECE_TP_DETAILS

Line 1699: from ece_tp_details etd,

1695: END IF;
1696:
1697: delete from po_purge_vendor_list pvl
1698: where exists (select null
1699: from ece_tp_details etd,
1700: ap_supplier_sites_all pvs
1701: where etd.tp_header_id = pvs.tp_header_id
1702: and pvs.vendor_id = pvl.vendor_id
1703: and etd.last_update_date > g_activity_date);

Line 3617: from ece_tp_details etd,

3613: update po_purge_vendor_list pvl
3614: set double_check_flag = 'N'
3615: where pvl.double_check_flag = 'Y'
3616: and (exists (select null
3617: from ece_tp_details etd,
3618: ap_supplier_sites_all pvs
3619: where etd.tp_header_id = pvs.tp_header_id
3620: and pvs.vendor_id = pvl.vendor_id
3621: and etd.last_update_date > g_activity_date));