APPS.AP_PURGE_PKG dependencies on AP_INVOICE_SELECTION_CRITERIA

Line 5301: FROM ap_checks C, ap_invoice_selection_criteria D

5297: RETURN BOOLEAN IS
5298:
5299: CURSOR setup_spoil_select is
5300: SELECT distinct C.checkrun_name
5301: FROM ap_checks C, ap_invoice_selection_criteria D
5302: WHERE D.LAST_UPDATE_DATE <= g_activity_date
5303: AND C.checkrun_name NOT IN
5304: (SELECT distinct b.checkrun_name
5305: FROM ap_checks a,

Line 5306: ap_invoice_selection_criteria b

5302: WHERE D.LAST_UPDATE_DATE <= g_activity_date
5303: AND C.checkrun_name NOT IN
5304: (SELECT distinct b.checkrun_name
5305: FROM ap_checks a,
5306: ap_invoice_selection_criteria b
5307: WHERE a.checkrun_name = b.checkrun_name
5308: AND a.status_lookup_code not in
5309: ('SET UP', 'SPOILED'))
5310: AND C.checkrun_name = D.checkrun_name

Line 5316: selected_checkrun ap_invoice_selection_criteria.checkrun_name%TYPE;

5312:
5313:
5314: debug_info VARCHAR2(200);
5315: current_calling_sequence VARCHAR2(2000);
5316: selected_checkrun ap_invoice_selection_criteria.checkrun_name%TYPE;
5317:
5318: BEGIN
5319:
5320: -- Update the calling sequence

Line 5368: DELETE FROM ap_invoice_selection_criteria C

5364: IF g_debug_switch in ('y','Y') THEN
5365: Print('(Setup_Spoil)'||debug_info);
5366: END IF;
5367:
5368: DELETE FROM ap_invoice_selection_criteria C
5369: WHERE C.checkrun_name = selected_checkrun
5370: AND C.last_update_date <= g_activity_date;
5371:
5372: END LOOP;