APPS.AP_AUTO_PAYMENT_PKG dependencies on AP_INVOICE_SELECTION_CRITERIA

Line 584: -- AP_INVOICE_SELECTION_CRITERIA AISC

580: --------------------------------------------------------------------------
581: -- Insert the records needed for the FORMAT program to work based on
582: -- P_check_id in the following tables:
583: --
584: -- AP_INVOICE_SELECTION_CRITERIA AISC
585: -- AP_SELECTED_INVOICE_CHECKS ASIC
586: -- AP_SELECTED_INVOICES ASI
587: --
588: -- NOTE: Records in ASIC and ASI will be deleted by the FORMAT program

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

597: -- END Insert_Temp_Records;
598:
599:
600: --------------------------------------------------------------------------
601: -- Return 'Y' if record exists in AP_INVOICE_SELECTION_CRITERIA
602: --
603: FUNCTION Selection_Criteria_Exists(P_check_id IN NUMBER)
604: RETURN VARCHAR2
605: IS

Line 635: l_checkrun_name ap_invoice_selection_criteria.checkrun_name%TYPE;

631: -- 'CONFIRMED', 'CANCELED', or 'QUICKCHECK'.
632: --
633: FUNCTION Get_Check_Stock_In_Use_By(p_check_stock_id IN NUMBER)
634: RETURN VARCHAR2 IS
635: l_checkrun_name ap_invoice_selection_criteria.checkrun_name%TYPE;
636: BEGIN
637:
638: SELECT checkrun_name
639: INTO l_checkrun_name

Line 640: FROM ap_invoice_selection_criteria

636: BEGIN
637:
638: SELECT checkrun_name
639: INTO l_checkrun_name
640: FROM ap_invoice_selection_criteria
641: WHERE check_stock_id = p_check_stock_id
642: AND status NOT IN ('CONFIRMED', 'CANCELED', 'QUICKCHECK');
643:
644: return(l_checkrun_name);