DBA Data[Home] [Help]

APPS.OKL_VENDOR_AGREEMENT_PUB dependencies on OKC_ROLE_SOURCES

Line 61: okc_role_sources rso

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
65: AND rso.buy_or_sell = 'S';