APPS.OKL_VENDOR_PROGRAM_PVT dependencies on OKC_K_HEADERS_B

Line 24: FROM okc_k_headers_b

20: G_VENDOR_RES_PECENT_RL CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'VGLRSP';
21:
22: CURSOR l_chr_csr2(contract_no VARCHAR2,contract_no_modifier VARCHAR2) IS
23: SELECT 'x'
24: FROM okc_k_headers_b
25: WHERE contract_number = contract_no
26: AND contract_number_modifier = contract_no_modifier;
27:
28: --Murthy Added Cursors for JTOT OBJECT CODE and check for CONTRACT ID

Line 644: FROM okc_k_headers_b chrb,

640:
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'

Line 1083: FROM okc_k_headers_b

1079: cpsv_rec_type4 process_rec_type;
1080:
1081: CURSOR l_chr_csr1(contract_id NUMBER, contract_no VARCHAR2,contract_no_modifier VARCHAR2) IS
1082: SELECT 'x'
1083: FROM okc_k_headers_b
1084: WHERE contract_number = contract_no
1085: AND contract_number_modifier = contract_no_modifier
1086: AND id <> NVL(contract_id,-99999);
1087:

Line 1089: SELECT v.contract_number FROM okc_k_headers_b v

1085: AND contract_number_modifier = contract_no_modifier
1086: AND id <> NVL(contract_id,-99999);
1087:
1088: CURSOR cur_k_header(program_id number) IS
1089: SELECT v.contract_number FROM okc_k_headers_b v
1090: WHERE v.id =program_id;
1091:
1092: CURSOR cur_k_process_id(program_id number) IS
1093: SELECT p.id