APPS.OKL_VENDOR_PROGRAM_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 39: SELECT id FROM okc_k_party_roles_b

35: AND rs.buy_or_sell = p_buy_or_sell AND sr.scs_code = p_scs_code;
36:
37: --Murthy
38: CURSOR cur_k_party_roles(contract_id NUMBER) IS
39: SELECT id FROM okc_k_party_roles_b
40: WHERE chr_id = contract_id AND rle_code = g_vendor_rle_code;
41:
42: CURSOR cur_parent_object_id(contract_id NUMBER) IS
43: SELECT object1_id1,object1_id2 FROM okc_k_party_roles_b

Line 43: SELECT object1_id1,object1_id2 FROM okc_k_party_roles_b

39: SELECT id FROM okc_k_party_roles_b
40: WHERE chr_id = contract_id AND rle_code = g_vendor_rle_code;
41:
42: CURSOR cur_parent_object_id(contract_id NUMBER) IS
43: SELECT object1_id1,object1_id2 FROM okc_k_party_roles_b
44: WHERE chr_id = contract_id AND rle_code = g_vendor_rle_code;
45:
46: CURSOR cur_k_header(parent_agreement_number VARCHAR2) IS
47: SELECT v.id

Line 125: FROM okc_k_party_roles_b

121: AND rs.buy_or_sell = p_buy_or_sell AND sr.scs_code = p_scs_code;
122: */
123: CURSOR cur_object_id(khr_id NUMBER) IS
124: SELECT jtot_object1_code, object1_id1, object1_id2
125: FROM okc_k_party_roles_b
126: WHERE dnz_chr_id = khr_id
127: AND rle_code = g_vendor_rle_code;
128:
129: --TYPE cur_contract_id_type IS REF CURSOR;

Line 637: FROM okc_k_party_roles_b

633: */
634:
635: CURSOR cur_object_id(khr_id NUMBER) IS
636: SELECT jtot_object1_code, object1_id1, object1_id2
637: FROM okc_k_party_roles_b
638: WHERE dnz_chr_id = khr_id
639: AND rle_code = g_vendor_rle_code;
640:
641: --Changed the cursor query to use base tables than uv --dkagrawa

Line 645: okc_k_party_roles_b kpr,

641: --Changed the cursor query to use base tables than uv --dkagrawa
642: CURSOR cur_vendor_name(chr_id NUMBER) IS
643: SELECT pov.vendor_name vendor_name
644: FROM okc_k_headers_b chrb,
645: okc_k_party_roles_b kpr,
646: po_vendors pov
647: WHERE chrb.id = kpr.dnz_chr_id
648: AND kpr.rle_code = 'OKL_VENDOR'
649: AND kpr.object1_id1 = pov.vendor_id