APPS.AHL_VWP_RULES_PVT dependencies on GL_SETS_OF_BOOKS

Line 2877: FROM qp_list_headers_vl qlhv, FINANCIALS_SYSTEM_PARAMETERS FSP, qp_qualifiers qpq, GL_SETS_OF_BOOKS GSB

2873: l_customer_id NUMBER;
2874:
2875: /*CURSOR price_list_id_csr(p_price_list_name IN VARCHAR2,p_customer_id IN NUMBER)IS
2876: SELECT qlhv.list_header_id
2877: FROM qp_list_headers_vl qlhv, FINANCIALS_SYSTEM_PARAMETERS FSP, qp_qualifiers qpq, GL_SETS_OF_BOOKS GSB
2878: WHERE FSP.set_of_books_id = GSB.set_of_books_id
2879: AND qlhv.list_type_code = 'PRL'
2880: AND qlhv.currency_code = gsb.currency_code
2881: AND UPPER(qlhv.name) like UPPER(p_price_list_name)

Line 2888: FROM qp_list_headers_vl qlhv,oe_agreements oa, qp_qualifiers qpq, FINANCIALS_SYSTEM_PARAMETERS FSP, GL_SETS_OF_BOOKS GSB

2884: AND qpq.qualifier_context = 'CUSTOMER'
2885: AND qpq.qualifier_attribute = 'QUALIFIER_ATTRIBUTE16'
2886: UNION
2887: SELECT qlhv.list_header_id
2888: FROM qp_list_headers_vl qlhv,oe_agreements oa, qp_qualifiers qpq, FINANCIALS_SYSTEM_PARAMETERS FSP, GL_SETS_OF_BOOKS GSB
2889: WHERE FSP.set_of_books_id = GSB.set_of_books_id
2890: AND ((oa.price_list_id = qlhv.list_header_id AND qlhv.list_type_code
2891: IN('PRL', 'AGR')) OR qlhv.list_type_code = 'PRL')
2892: AND qlhv.currency_code = gsb.currency_code

Line 3266: FROM cst_acct_info_v COD, GL_SETS_OF_BOOKS GSOB

3262:
3263: -- AnRaj:Changes made for fixing bug#4919353, issue# 7
3264: CURSOR currency_code_csr(p_org_id IN NUMBER) IS
3265: SELECT currency_code
3266: FROM cst_acct_info_v COD, GL_SETS_OF_BOOKS GSOB
3267: WHERE COD.Organization_Id = p_org_id
3268: AND LEDGER_ID = GSOB.SET_OF_BOOKS_ID
3269: AND NVL(operating_unit, mo_global.get_current_org_id())= mo_global.get_current_org_id();
3270: