APPS.AP_AUTO_PAYMENT_PKG dependencies on AP_INVOICE_SELECTION_CRITERIA

Line 673: -- AP_INVOICE_SELECTION_CRITERIA AISC

669: --------------------------------------------------------------------------
670: -- Insert the records needed for the FORMAT program to work based on
671: -- P_check_id in the following tables:
672: --
673: -- AP_INVOICE_SELECTION_CRITERIA AISC
674: -- AP_SELECTED_INVOICE_CHECKS ASIC
675: -- AP_SELECTED_INVOICES ASI
676: --
677: -- NOTE: Records in ASIC and ASI will be deleted by the FORMAT program

Line 690: -- Return 'Y' if record exists in AP_INVOICE_SELECTION_CRITERIA

686: -- END Insert_Temp_Records;
687:
688:
689: --------------------------------------------------------------------------
690: -- Return 'Y' if record exists in AP_INVOICE_SELECTION_CRITERIA
691: --
692: FUNCTION Selection_Criteria_Exists(P_check_id IN NUMBER)
693: RETURN VARCHAR2
694: IS

Line 724: l_checkrun_name ap_invoice_selection_criteria.checkrun_name%TYPE;

720: -- 'CONFIRMED', 'CANCELED', or 'QUICKCHECK'.
721: --
722: FUNCTION Get_Check_Stock_In_Use_By(p_check_stock_id IN NUMBER)
723: RETURN VARCHAR2 IS
724: l_checkrun_name ap_invoice_selection_criteria.checkrun_name%TYPE;
725: BEGIN
726:
727: SELECT checkrun_name
728: INTO l_checkrun_name

Line 729: FROM ap_invoice_selection_criteria

725: BEGIN
726:
727: SELECT checkrun_name
728: INTO l_checkrun_name
729: FROM ap_invoice_selection_criteria
730: WHERE check_stock_id = p_check_stock_id
731: AND status NOT IN ('CONFIRMED', 'CANCELED', 'QUICKCHECK');
732:
733: return(l_checkrun_name);