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 594: FROM OKC_K_HEADERS_V

590:
591: CURSOR c_ctr_no(p_ctr_id IN NUMBER)
592: IS
593: SELECT contract_number
594: FROM OKC_K_HEADERS_V
595: WHERE id=p_ctr_id;
596:
597: --Cursor for obtaining the party name on the old contract
598: CURSOR c_party(p_contract_id IN NUMBER) IS

Line 3065: FROM OKC_K_HEADERS_V

3061: l_req_rec c_req_record%ROWTYPE;
3062:
3063: CURSOR c_ctr_no(p_ctr_id IN NUMBER) IS
3064: SELECT contract_number
3065: FROM OKC_K_HEADERS_V
3066: WHERE id=p_ctr_id;
3067: BEGIN
3068:
3069: if (funcmode = 'RUN') then

Line 3391: FROM OKC_K_HEADERS_V

3387: l_req_rec c_req_record%ROWTYPE;
3388:
3389: CURSOR c_ctr_no(p_ctr_id IN NUMBER) IS
3390: SELECT contract_number
3391: FROM OKC_K_HEADERS_V
3392: WHERE id=p_ctr_id;
3393: BEGIN
3394:
3395: if (funcmode = 'RUN') then

Line 3832: FROM OKC_K_HEADERS_V

3828: l_req_rec c_req_record%ROWTYPE;
3829:
3830: CURSOR c_ctr_no(p_ctr_id IN NUMBER) IS
3831: SELECT contract_number
3832: FROM OKC_K_HEADERS_V
3833: WHERE id=p_ctr_id;
3834: BEGIN
3835:
3836: if (funcmode = 'RUN') then