APPS.OKL_VP_SYNC_CR_PVT dependencies on OKC_RG_ROLE_DEFS

Line 1325: ,okc_rg_role_defs rrd

1321: FROM okc_k_headers_b chr
1322: ,okc_subclass_roles sre
1323: ,okc_role_sources rse
1324: ,okc_subclass_rg_defs srd
1325: ,okc_rg_role_defs rrd
1326: WHERE chr.id = cp_chr_id
1327: AND sre.scs_code = chr.scs_code
1328: AND sre.rle_code = rse.rle_code
1329: AND rse.rle_code = 'OKL_VENDOR'

Line 1335: lv_orig_rrd_id okc_rg_role_defs.id%TYPE;

1331: AND srd.scs_code = chr.scs_code
1332: AND srd.rgd_code = 'LAVENB'
1333: AND rrd.srd_id = srd.id
1334: AND rrd.sre_id = sre.id;
1335: lv_orig_rrd_id okc_rg_role_defs.id%TYPE;
1336:
1337: -- cursor that fetches party role id of Lease Vendor
1338: CURSOR c_get_cpl_id_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
1339: SELECT id