DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on QP_LIST_HEADERS_B

Line 1404: FROM QP_LIST_HEADERS_B

1400: IS
1401:
1402: Cursor c_price_list(p_price_list_id IN NUMBER) IS
1403: SELECT list_header_id
1404: FROM QP_LIST_HEADERS_B
1405: WHERE list_type_code in ('PRL','AGR')
1406: AND list_header_id = p_price_list_id
1407: AND sysdate between nvl(start_date_active,sysdate) and
1408: nvl(end_date_active,sysdate);

Line 3658: FROM qp_currency_details a,qp_list_headers_b b

3654: IS
3655:
3656: Cursor c_currency_code(p_price_list_id NUMBER,p_currency_code VARCHAR2) IS
3657: SELECT 'Y'
3658: FROM qp_currency_details a,qp_list_headers_b b
3659: where list_header_id = p_price_list_id
3660: and a.currency_header_id = b.currency_header_id
3661: and to_currency_code = p_currency_code;
3662: