APPS.OKC_CONTRACT_PUB dependencies on OKC_STATUSES_V

Line 5686: from okc_statuses_v

5682:
5683: --
5684: cursor c_type is
5685: select ste_code
5686: from okc_statuses_v
5687: where code=p_sts_code;
5688: --
5689: l_signed varchar2(30);
5690: --

Line 5693: from okc_statuses_v

5689: l_signed varchar2(30);
5690: --
5691: cursor c_signed is
5692: select code
5693: from okc_statuses_v
5694: where ste_code='SIGNED'
5695: and default_yn='Y';
5696: --
5697: l_expired varchar2(30);

Line 5701: from okc_statuses_v

5697: l_expired varchar2(30);
5698: --
5699: cursor c_expired is
5700: select code
5701: from okc_statuses_v
5702: where ste_code='EXPIRED'
5703: and default_yn='Y';
5704: --
5705: cursor c_lines is

Line 5711: from okc_k_headers_v H, okc_k_lines_v L, okc_statuses_v S

5707: decode(sign(months_between(sysdate-1,NVL(L.end_date,sysdate))),-1,
5708: decode(sign(months_between(L.start_date-1,sysdate)),-1,p_sts_code,l_signed)
5709: ,l_expired)
5710: ,p_sts_code) code
5711: from okc_k_headers_v H, okc_k_lines_v L, okc_statuses_v S
5712: where H.id= p_id
5713: and L.dnz_chr_id = p_id
5714: and S.code = L.sts_code
5715: and S.ste_code in ('ENTERED','CANCELLED','ACTIVE','SIGNED','HOLD');