APPS.OKS_EXTWAR_UTIL_PUB dependencies on OKC_STATUSES_V

Line 1749: FROM okc_statuses_v

1745: SELECT contact_id,authoring_org_id
1746: FROM oks_k_res_temp
1747: WHERE status IN
1748: (SELECT code
1749: FROM okc_statuses_v
1750: WHERE ste_code IN('ACTIVE','SIGNED','HOLD'))
1751: AND contact_id IS NOT NULL;
1752:
1753: CURSOR delete_contact_resource IS

Line 1758: FROM okc_statuses_v

1754: SELECT contact_id,authoring_org_id
1755: FROM oks_k_res_temp
1756: WHERE status IN
1757: (SELECT code
1758: FROM okc_statuses_v
1759: WHERE ste_code = 'ENTERED')
1760: AND contact_id IS NOT NULL;
1761:
1762: CURSOR contact_resource_in_future IS

Line 1767: FROM okc_statuses_v

1763: SELECT id,contract_number,contract_number_modifier
1764: FROM oks_k_res_temp
1765: WHERE status IN
1766: (SELECT code
1767: FROM okc_statuses_v
1768: WHERE ste_code IN('ACTIVE','SIGNED','HOLD'))
1769: AND contact_start_date >= trunc(sysdate) ;
1770:
1771: CURSOR contract_noresource IS

Line 2432: FROM okc_statuses_v

2428: FROM oks_k_res_temp b
2429: WHERE b.id = a.id
2430: AND b.contact_start_date >= trunc(sysdate)
2431: AND b.status IN (SELECT code
2432: FROM okc_statuses_v
2433: WHERE ste_code IN('ACTIVE','SIGNED','HOLD'))
2434: );
2435:
2436: -- Now delete those contracts from oks_jtf_res_temp which are deleted from oks_k_res_temp