APPS.OKE_CONTRACT_APPROVAL_PVT dependencies on OKC_STATUSES_B

Line 1482: select code from okc_statuses_b

1478: l_signed_status varchar2(30);
1479: l_active_status varchar2(30);
1480: l_expired_status varchar2(30);
1481: cursor c1 is
1482: select code from okc_statuses_b
1483: where ste_code='SIGNED'
1484: and default_yn='Y';
1485: cursor c2 is
1486: select code from okc_statuses_b

Line 1486: select code from okc_statuses_b

1482: select code from okc_statuses_b
1483: where ste_code='SIGNED'
1484: and default_yn='Y';
1485: cursor c2 is
1486: select code from okc_statuses_b
1487: where ste_code='ACTIVE'
1488: and default_yn='Y';
1489: cursor c3 is
1490: select code from okc_statuses_b

Line 1490: select code from okc_statuses_b

1486: select code from okc_statuses_b
1487: where ste_code='ACTIVE'
1488: and default_yn='Y';
1489: cursor c3 is
1490: select code from okc_statuses_b
1491: where ste_code='EXPIRED'
1492: and default_yn='Y';
1493: --
1494: cursor lock1_csr is

Line 1501: , okc_statuses_b S

1497: decode(sign(months_between(p_date_signed-1,sysdate)),-1,
1498: decode(sign(months_between(L.start_date-1,sysdate)),-1,
1499: l_active_status,l_signed_status),l_signed_status),l_expired_status) STS_CODE
1500: from okc_k_lines_b L
1501: , okc_statuses_b S
1502: where L.dnz_chr_id = p_contract_id
1503: and S.code = L.sts_code
1504: and S.ste_code='ENTERED'
1505: ;