DBA Data[Home] [Help]

APPS.OKL_DEAL_PARTIES_PVT dependencies on OKC_ROLE_SOURCES

Line 51: okc_role_sources rse,

47: CURSOR c_get_rrd_id(p_chr_id NUMBER, p_rle_code VARCHAR2, p_rgd_code VARCHAR2) IS
48: SELECT rgrdfs.id
49: FROM okc_k_headers_b chr,
50: okc_subclass_roles sre,
51: okc_role_sources rse,
52: okc_subclass_rg_defs rgdfs,
53: okc_rg_role_defs rgrdfs
54: WHERE chr.id = p_chr_id
55: AND sre.scs_code = chr.scs_code

Line 415: okc_role_sources rse,

411: CURSOR c_get_rrd_id(p_chr_id NUMBER, p_rle_code VARCHAR2, p_rgd_code VARCHAR2) IS
412: SELECT rgrdfs.id
413: FROM okc_k_headers_b chr,
414: okc_subclass_roles sre,
415: okc_role_sources rse,
416: okc_subclass_rg_defs rgdfs,
417: okc_rg_role_defs rgrdfs
418: WHERE chr.id = p_chr_id
419: AND sre.scs_code = chr.scs_code

Line 592: okc_role_sources rse,

588: CURSOR c_get_rrd_id(p_chr_id NUMBER, p_rle_code VARCHAR2, p_rgd_code VARCHAR2) IS
589: SELECT rgrdfs.id
590: FROM okc_k_headers_b chr,
591: okc_subclass_roles sre,
592: okc_role_sources rse,
593: okc_subclass_rg_defs rgdfs,
594: okc_rg_role_defs rgrdfs
595: WHERE chr.id = p_chr_id
596: AND sre.scs_code = chr.scs_code