[Home] [Help]
4288: cpl.role party_role,
4289: cpl.cust_acct_id cust_acct_id
4290: FROM okc_k_party_roles_v cpl,
4291: okc_rg_party_roles rgpr,
4292: okc_rule_groups_v rgd
4293: WHERE cpl.id = cp_cpl_id
4294: AND cpl.rle_code = 'OKL_VENDOR'
4295: AND rgpr.cpl_id (+) = cpl.id
4296: AND rgd.id (+) = rgpr.rgp_id
4309: -- cPl.ROLE ParACty_Role,
4310: cPl.cUst_acct_Id cUst_acct_Id
4311: FROM Okl_k_Headers khr,
4312: Okc_k_Headers_b Par,
4313: Okc_Rule_Groups_v rgd,
4314: Okc_k_Party_Roles_b cPl
4315: WHERE khr.Id = cp_khr_Id
4316: AND Par.Id = khr.khr_Id
4317: AND Par.scs_Code = 'PROGRAM'