APPS.ASO_SOURCING_PVT dependencies on ASO_PAYMENTS

Line 633: Cursor get_po is SELECT payment_ref_number from aso_payments

629: FUNCTION Get_Cust_Po(
630: p_qte_header_id number
631: ) RETURN VARCHAR2
632: IS
633: Cursor get_po is SELECT payment_ref_number from aso_payments
634: WHERE
635: payment_type_code ='PO' and quote_header_id = p_qte_header_id and quote_line_id is NULL;
636: Customer_PO VARCHAR2(240);
637:

Line 653: Cursor get_po is SELECT payment_ref_number from aso_payments

649: FUNCTION Get_line_Cust_Po(
650: p_qte_line_id number
651: ) RETURN VARCHAR2
652: IS
653: Cursor get_po is SELECT payment_ref_number from aso_payments
654: WHERE
655: payment_type_code ='PO' and quote_line_id = p_qte_line_id;
656: Customer_PO VARCHAR2(240);
657:

Line 748: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments

744: p_qte_header_id number
745: ) RETURN NUMBER
746: IS
747:
748: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments
749: WHERE
750: quote_header_id = p_qte_header_id and quote_line_id IS null;
751: l_pmnt_term_id NUMBER;
752: BEGIN

Line 771: Cursor get_hdr_pmnt_term is SELECT payment_term_id from aso_payments

767: FUNCTION Get_line_Payment_term(
768: p_qte_line_id number,p_qte_header_id number
769: ) RETURN NUMBER
770: IS
771: Cursor get_hdr_pmnt_term is SELECT payment_term_id from aso_payments
772: WHERE
773: quote_header_id = p_qte_header_id and quote_line_id IS null;
774:
775: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments

Line 775: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments

771: Cursor get_hdr_pmnt_term is SELECT payment_term_id from aso_payments
772: WHERE
773: quote_header_id = p_qte_header_id and quote_line_id IS null;
774:
775: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments
776: WHERE
777: quote_line_id = p_qte_line_id;
778: l_pmnt_term_id NUMBER;
779: BEGIN