APPS.OKC_OC_INT_KTQ_PVT dependencies on OKC_ROLE_SOURCES

Line 401: ,okc_role_sources rsc

397: ,cpr.object1_id1
398: ,cpr.object1_id2
399: ,cpr.rle_code
400: FROM okc_k_party_roles_b cpr
401: ,okc_role_sources rsc
402: WHERE
403: rsc.buy_or_sell = 'S' -- sell contract
404: AND rsc.rle_code = cpr.rle_code -- role
405: AND rsc.start_date <= sysdate

Line 1603: l_prev_rle_code okc_role_sources.rle_code%TYPE;

1599: l_lines NUMBER;
1600: l_nb_parties NUMBER;
1601: l_nb_roles NUMBER;
1602: l_legentity NUMBER;
1603: l_prev_rle_code okc_role_sources.rle_code%TYPE;
1604: l_err_nb NUMBER;
1605: l_sql VARCHAR2(2000);
1606: l_item_name VARCHAR2(150);
1607: l_customer_order_enabled_flag VARCHAR2(1);