APPS.OKL_VENDOR_AGREEMENT_PUB dependencies on OKC_SUBCLASS_ROLES

Line 60: FROM okc_subclass_roles sre,

56:
57: -- Get Party Type
58: CURSOR get_party_role_jtot (p_rle_code IN VARCHAR2, p_category IN VARCHAR2) IS
59: SELECT rso.jtot_object_code
60: FROM okc_subclass_roles sre,
61: okc_role_sources rso
62: WHERE sre.scs_code = p_category
63: AND rso.rle_code = sre.rle_code
64: AND rso.rle_code = p_rle_code

Line 91: from okc_subclass_roles

87: CURSOR get_rrd_id IS
88: select id
89: from okc_rg_role_defs
90: where sre_id = (select id
91: from okc_subclass_roles
92: where scs_code = 'PROGRAM' and rle_code = 'OKL_VENDOR')
93: and srd_id = ( select id
94: from okc_subclass_rg_defs
95: where scs_code = 'PROGRAM' and rgd_code = 'LAVENB');