APPS.OKS_CHANGE_STATUS_PVT dependencies on OKC_STATUSES_V

Line 1128: from okc_statuses_v

1124: l_scs_code varchar2(30);
1125: --
1126: cursor c_type is
1127: select ste_code
1128: from okc_statuses_v
1129: where code=p_new_sts_code;
1130:
1131: -- bug#6144856 --
1132:

Line 1135: from okc_statuses_v

1131: -- bug#6144856 --
1132:
1133: cursor c_old_type is
1134: select ste_code
1135: from okc_statuses_v
1136: where code=p_old_sts_code;
1137:
1138: l_old_type varchar2(30);
1139:

Line 1154: from okc_statuses_v

1150: l_signed varchar2(30);
1151: --
1152: cursor c_signed is
1153: select code
1154: from okc_statuses_v
1155: where ste_code='SIGNED'
1156: and default_yn='Y';
1157: --
1158: l_expired varchar2(30);

Line 1162: from okc_statuses_v

1158: l_expired varchar2(30);
1159: --
1160: cursor c_expired is
1161: select code
1162: from okc_statuses_v
1163: where ste_code='EXPIRED'
1164: and default_yn='Y';
1165: --
1166:

Line 1250: from okc_k_lines_v L, okc_statuses_v ls

1246: decode(sign(months_between(L.start_date-1,sysdate)),-1,p_new_sts_code,l_signed)
1247: ,l_expired)
1248: ,p_new_sts_code) code, L.lse_id,
1249: L.object_version_number
1250: from okc_k_lines_v L, okc_statuses_v ls
1251: where L.dnz_chr_id = p_id
1252: and ls.code = L.sts_code
1253: and ls.ste_code in (l_old_type,'SIGNED')
1254: and NVL(L.term_cancel_source,'MANUAL') NOT IN ('IBTRANSFER', 'IBRETURN', 'IBTERMINATE', 'IBREPLACE'); --To ignore lines/sublines due to IBTRANSFER, IBRETURN, IBTERMINATE, IBREPLACE

Line 1264: from okc_k_lines_v L, okc_statuses_v ls

1260: decode(sign(months_between(L.start_date-1,sysdate)),-1,p_new_sts_code,l_signed)
1261: ,l_expired)
1262: ,p_new_sts_code) code, L.lse_id,
1263: L.object_version_number
1264: from okc_k_lines_v L, okc_statuses_v ls
1265: where L.dnz_chr_id = p_id
1266: and ls.code = L.sts_code
1267: and ls.ste_code in (l_type,l_old_type)
1268: and NVL(L.term_cancel_source,'MANUAL') NOT IN ('IBTRANSFER', 'IBRETURN', 'IBTERMINATE', 'IBREPLACE'); --To ignore lines/sublines due to IBTRANSFER, IBRETURN, IBTERMINATE, IBREPLACE

Line 1816: okc_statuses_v S

1812: (select
1813: S.CODE STATUS_CODE
1814: ,S.STE_CODE STE_CODE
1815: from
1816: okc_statuses_v S
1817: ,fnd_lookups ST
1818: where
1819: S.STE_CODE in
1820: (

Line 1847: FROM OKC_STATUSES_V S

1843: AND l_old_ste_code <> 'CANCELLED'
1844: UNION ALL
1845: SELECT S.CODE STATUS_CODE
1846: ,S.STE_CODE STE_CODE1
1847: FROM OKC_STATUSES_V S
1848: ,FND_LOOKUPS ST
1849: WHERE S.STE_CODE in ('ENTERED', 'CANCELLED')
1850: AND SYSDATE BETWEEN S.START_DATE AND NVL(S.END_DATE, SYSDATE)
1851: AND ST.LOOKUP_TYPE = 'OKC_STATUS_TYPE'