APPS.OKS_CHANGE_STATUS_PVT dependencies on OKC_STATUSES_V

Line 1171: from okc_statuses_v

1167: l_scs_code varchar2(30);
1168: --
1169: cursor c_type is
1170: select ste_code
1171: from okc_statuses_v
1172: where code=p_new_sts_code;
1173:
1174: -- bug#6144856 --
1175:

Line 1178: from okc_statuses_v

1174: -- bug#6144856 --
1175:
1176: cursor c_old_type is
1177: select ste_code
1178: from okc_statuses_v
1179: where code=p_old_sts_code;
1180:
1181: l_old_type varchar2(30);
1182:

Line 1197: from okc_statuses_v

1193: l_signed varchar2(30);
1194: --
1195: cursor c_signed is
1196: select code
1197: from okc_statuses_v
1198: where ste_code='SIGNED'
1199: and default_yn='Y';
1200: --
1201: l_expired varchar2(30);

Line 1205: from okc_statuses_v

1201: l_expired varchar2(30);
1202: --
1203: cursor c_expired is
1204: select code
1205: from okc_statuses_v
1206: where ste_code='EXPIRED'
1207: and default_yn='Y';
1208: --
1209:

Line 1293: from okc_k_lines_v L, okc_statuses_v ls

1289: decode(sign(months_between(L.start_date-1,sysdate)),-1,p_new_sts_code,l_signed)
1290: ,l_expired)
1291: ,p_new_sts_code) code, L.lse_id,
1292: L.object_version_number
1293: from okc_k_lines_v L, okc_statuses_v ls
1294: where L.dnz_chr_id = p_id
1295: and ls.code = L.sts_code
1296: and ls.ste_code in (l_old_type,'SIGNED')
1297: and NVL(L.term_cancel_source,'MANUAL') NOT IN ('IBTRANSFER', 'IBRETURN', 'IBTERMINATE', 'IBREPLACE'); --To ignore lines/sublines due to IBTRANSFER, IBRETURN, IBTERMINATE, IBREPLACE

Line 1307: from okc_k_lines_v L, okc_statuses_v ls

1303: decode(sign(months_between(L.start_date-1,sysdate)),-1,p_new_sts_code,l_signed)
1304: ,l_expired)
1305: ,p_new_sts_code) code, L.lse_id,
1306: L.object_version_number
1307: from okc_k_lines_v L, okc_statuses_v ls
1308: where L.dnz_chr_id = p_id
1309: and ls.code = L.sts_code
1310: and ls.ste_code in (l_type,l_old_type)
1311: and NVL(L.term_cancel_source,'MANUAL') NOT IN ('IBTRANSFER', 'IBRETURN', 'IBTERMINATE', 'IBREPLACE'); --To ignore lines/sublines due to IBTRANSFER, IBRETURN, IBTERMINATE, IBREPLACE

Line 1872: okc_statuses_v S

1868: (select
1869: S.CODE STATUS_CODE
1870: ,S.STE_CODE STE_CODE
1871: from
1872: okc_statuses_v S
1873: ,fnd_lookups ST
1874: where
1875: S.STE_CODE in
1876: (

Line 1903: FROM OKC_STATUSES_V S

1899: AND l_old_ste_code <> 'CANCELLED'
1900: UNION ALL
1901: SELECT S.CODE STATUS_CODE
1902: ,S.STE_CODE STE_CODE1
1903: FROM OKC_STATUSES_V S
1904: ,FND_LOOKUPS ST
1905: WHERE S.STE_CODE in ('ENTERED', 'CANCELLED')
1906: AND SYSDATE BETWEEN S.START_DATE AND NVL(S.END_DATE, SYSDATE)
1907: AND ST.LOOKUP_TYPE = 'OKC_STATUS_TYPE'