APPS.AP_PURGE_PKG dependencies on AP_INVOICE_SELECTION_CRITERIA

Line 4812: FROM ap_checks C, ap_invoice_selection_criteria D

4808: RETURN BOOLEAN IS
4809:
4810: CURSOR setup_spoil_select is
4811: SELECT distinct C.checkrun_name
4812: FROM ap_checks C, ap_invoice_selection_criteria D
4813: WHERE D.LAST_UPDATE_DATE <= g_activity_date
4814: AND C.checkrun_name NOT IN
4815: (SELECT distinct b.checkrun_name
4816: FROM ap_checks a,

Line 4817: ap_invoice_selection_criteria b

4813: WHERE D.LAST_UPDATE_DATE <= g_activity_date
4814: AND C.checkrun_name NOT IN
4815: (SELECT distinct b.checkrun_name
4816: FROM ap_checks a,
4817: ap_invoice_selection_criteria b
4818: WHERE a.checkrun_name = b.checkrun_name
4819: AND a.status_lookup_code not in
4820: ('SET UP', 'SPOILED'))
4821: AND C.checkrun_name = D.checkrun_name

Line 4827: selected_checkrun ap_invoice_selection_criteria.checkrun_name%TYPE;

4823:
4824:
4825: debug_info VARCHAR2(200);
4826: current_calling_sequence VARCHAR2(2000);
4827: selected_checkrun ap_invoice_selection_criteria.checkrun_name%TYPE;
4828:
4829: BEGIN
4830:
4831: -- Update the calling sequence

Line 4879: DELETE FROM ap_invoice_selection_criteria C

4875: IF g_debug_switch in ('y','Y') THEN
4876: Print('(Setup_Spoil)'||debug_info);
4877: END IF;
4878:
4879: DELETE FROM ap_invoice_selection_criteria C
4880: WHERE C.checkrun_name = selected_checkrun
4881: AND C.last_update_date <= g_activity_date;
4882:
4883: END LOOP;