APPS.ASO_PRICING_INT dependencies on ASO_PAYMENTS

Line 1605: Cursor get_po is SELECT payment_ref_number from aso_payments

1601: FUNCTION Get_Cust_Po(
1602: p_qte_header_id number
1603: ) RETURN VARCHAR2
1604: IS
1605: Cursor get_po is SELECT payment_ref_number from aso_payments
1606: WHERE
1607: payment_type_code ='PO' and quote_header_id = p_qte_header_id and quote_line_id is NULL;
1608: Customer_PO VARCHAR2(240);
1609:

Line 1621: Cursor get_po is SELECT payment_ref_number from aso_payments

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

Line 1711: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments

1707: p_qte_header_id number
1708: ) RETURN NUMBER
1709: IS
1710:
1711: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments
1712: WHERE
1713: quote_header_id = p_qte_header_id and quote_line_id IS null;
1714: l_pmnt_term_id NUMBER;
1715: BEGIN

Line 1728: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments

1724: p_qte_line_id number
1725: ) RETURN NUMBER
1726: IS
1727:
1728: Cursor get_pmnt_term is SELECT payment_term_id from aso_payments
1729: WHERE
1730: quote_line_id = p_qte_line_id;
1731: l_pmnt_term_id NUMBER;
1732: BEGIN