APPS.OKL_AM_INVOICES_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 128: FROM okc_k_party_roles_v cpl,

124: cpl.object1_id2 object1_id2,
125: rgd.id rgd_id,
126: cpl.bill_to_site_use_id bill_to_site_use_id, -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
127: cpl.role party_role -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
128: FROM okc_k_party_roles_v cpl,
129: okc_rg_party_roles rgpr,
130: okc_rule_groups_v rgd
131: WHERE cpl.id = cp_cpl_id
132: AND cpl.rle_code = 'OKL_VENDOR'

Line 141: -- PAGARG Bug 3559535 Make join of okc_k_headers_b par with okc_k_party_roles_v

137: -- This cursor called from REPURCHASE QUOTE
138: -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
139: -- Get bill to site of vendor PROGRAM
140: -- RMUNJULU 3300594 Changed way to get bill_to_site_use_id, get from CPL not PAR
141: -- PAGARG Bug 3559535 Make join of okc_k_headers_b par with okc_k_party_roles_v
142: -- as outer join so that it returns te record of contract even if vendor program
143: -- is not there for that contract
144: CURSOR l_partner_rg_csr (cp_khr_id IN NUMBER) IS
145: SELECT khr.id khr_id,

Line 153: okc_k_party_roles_v cpl -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes

149: cpl.role party_role -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
150: FROM okl_k_headers khr,
151: okc_k_headers_all_b par,
152: okc_rule_groups_b rgd,
153: okc_k_party_roles_v cpl -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
154: WHERE khr.id = cp_khr_id
155: AND par.id (+) = khr.khr_id
156: AND par.scs_code (+) = 'PROGRAM'
157: AND rgd.chr_id (+) = par.id