APPS.ASO_PRICING_INT dependencies on ASO_PAYMENTS

Line 1620: Cursor get_po is SELECT payment_ref_number from aso_payments

1616: FUNCTION Get_Cust_Po(
1617: p_qte_header_id number
1618: ) RETURN VARCHAR2
1619: IS
1620: Cursor get_po is SELECT payment_ref_number from aso_payments
1621: WHERE
1622: payment_type_code ='PO' and quote_header_id = p_qte_header_id and quote_line_id is NULL;
1623: Customer_PO VARCHAR2(240);
1624:

Line 1636: Cursor get_po is SELECT payment_ref_number from aso_payments

1632: FUNCTION Get_line_Cust_Po(
1633: p_qte_line_id number
1634: ) RETURN VARCHAR2
1635: IS
1636: Cursor get_po is SELECT payment_ref_number from aso_payments
1637: WHERE
1638: payment_type_code ='PO' and quote_line_id = p_qte_line_id;
1639: Customer_PO VARCHAR2(240);
1640:

Line 1726: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments

1722: p_qte_header_id number
1723: ) RETURN NUMBER
1724: IS
1725:
1726: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments
1727: WHERE
1728: quote_header_id = p_qte_header_id and quote_line_id IS null;
1729: l_pmnt_term_id NUMBER;
1730: BEGIN

Line 1743: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments

1739: p_qte_line_id number
1740: ) RETURN NUMBER
1741: IS
1742:
1743: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments
1744: WHERE
1745: quote_line_id = p_qte_line_id;
1746: l_pmnt_term_id NUMBER;
1747: BEGIN