DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on OKL_K_HEADERS

Line 1773: FROM okl_k_headers_v

1769: resultout out nocopy varchar2) IS
1770:
1771: CURSOR c_vnd_pgm(p_ctr_id IN NUMBER) IS
1772: SELECT khr_id
1773: FROM okl_k_headers_v
1774: where id = p_ctr_id ;
1775:
1776: CURSOR c_contact_role(p_contract_id IN NUMBER) IS
1777: SELECT co.object1_id1,

Line 2910: FROM okl_k_headers a,okl_products b

2906: IS
2907: CURSOR products_csr(c_contract_id NUMBER)
2908: IS
2909: SELECT b.id,b.name,b.description
2910: FROM okl_k_headers a,okl_products b
2911: WHERE a.pdt_id=b.id
2912: AND a.pdt_id is not null
2913: AND a.id=c_contract_id;
2914: BEGIN