APPS.AHL_VWP_RULES_PVT dependencies on GL_SETS_OF_BOOKS

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

2554: l_customer_id NUMBER;
2555:
2556: /*CURSOR price_list_id_csr(p_price_list_name IN VARCHAR2,p_customer_id IN NUMBER)IS
2557: SELECT qlhv.list_header_id
2558: FROM qp_list_headers_vl qlhv, FINANCIALS_SYSTEM_PARAMETERS FSP, qp_qualifiers qpq, GL_SETS_OF_BOOKS GSB
2559: WHERE FSP.set_of_books_id = GSB.set_of_books_id
2560: AND qlhv.list_type_code = 'PRL'
2561: AND qlhv.currency_code = gsb.currency_code
2562: AND UPPER(qlhv.name) like UPPER(p_price_list_name)

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

2565: AND qpq.qualifier_context = 'CUSTOMER'
2566: AND qpq.qualifier_attribute = 'QUALIFIER_ATTRIBUTE16'
2567: UNION
2568: SELECT qlhv.list_header_id
2569: FROM qp_list_headers_vl qlhv,oe_agreements oa, qp_qualifiers qpq, FINANCIALS_SYSTEM_PARAMETERS FSP, GL_SETS_OF_BOOKS GSB
2570: WHERE FSP.set_of_books_id = GSB.set_of_books_id
2571: AND ((oa.price_list_id = qlhv.list_header_id AND qlhv.list_type_code
2572: IN('PRL', 'AGR')) OR qlhv.list_type_code = 'PRL')
2573: AND qlhv.currency_code = gsb.currency_code

Line 2947: FROM cst_acct_info_v COD, GL_SETS_OF_BOOKS GSOB

2943:
2944: -- AnRaj:Changes made for fixing bug#4919353, issue# 7
2945: CURSOR currency_code_csr(p_org_id IN NUMBER) IS
2946: SELECT currency_code
2947: FROM cst_acct_info_v COD, GL_SETS_OF_BOOKS GSOB
2948: WHERE COD.Organization_Id = p_org_id
2949: AND LEDGER_ID = GSOB.SET_OF_BOOKS_ID
2950: AND NVL(operating_unit, mo_global.get_current_org_id())= mo_global.get_current_org_id();
2951: