DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on OKC_K_HEADERS_V

Line 264: FROM OKC_K_HEADERS_V

260:
261: CURSOR okl_contract_number(c_contract_id NUMBER)
262: IS
263: SELECT contract_number
264: FROM OKC_K_HEADERS_V
265: WHERE id=c_contract_id;
266: BEGIN
267:
268: l_thpv_tbl(1).id:= p_tas_id;

Line 603: FROM OKC_K_HEADERS_V

599:
600: CURSOR c_ctr_no(p_ctr_id IN NUMBER)
601: IS
602: SELECT contract_number
603: FROM OKC_K_HEADERS_V
604: WHERE id=p_ctr_id;
605:
606: --Cursor for obtaining the party name on the old contract
607: CURSOR c_party(p_contract_id IN NUMBER) IS

Line 3074: FROM OKC_K_HEADERS_V

3070: l_req_rec c_req_record%ROWTYPE;
3071:
3072: CURSOR c_ctr_no(p_ctr_id IN NUMBER) IS
3073: SELECT contract_number
3074: FROM OKC_K_HEADERS_V
3075: WHERE id=p_ctr_id;
3076: BEGIN
3077:
3078: if (funcmode = 'RUN') then

Line 3400: FROM OKC_K_HEADERS_V

3396: l_req_rec c_req_record%ROWTYPE;
3397:
3398: CURSOR c_ctr_no(p_ctr_id IN NUMBER) IS
3399: SELECT contract_number
3400: FROM OKC_K_HEADERS_V
3401: WHERE id=p_ctr_id;
3402: BEGIN
3403:
3404: if (funcmode = 'RUN') then

Line 3841: FROM OKC_K_HEADERS_V

3837: l_req_rec c_req_record%ROWTYPE;
3838:
3839: CURSOR c_ctr_no(p_ctr_id IN NUMBER) IS
3840: SELECT contract_number
3841: FROM OKC_K_HEADERS_V
3842: WHERE id=p_ctr_id;
3843: BEGIN
3844:
3845: if (funcmode = 'RUN') then