APPS.OKS_CHANGE_STATUS_PVT dependencies on OKC_STATUSES_B

Line 756: okc_statuses_b STE,

752: SELECT contract_number, contract_number_modifier,
753: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contracts
754: FROM okc_k_headers_b CHR,
755: okc_k_lines_b CLE,
756: okc_statuses_b STE,
757: okc_operation_lines OLI1,
758: okc_operation_lines OLI2,
759: okc_operation_instances OIE1,
760: okc_class_operations COP1,

Line 853: okc_statuses_b STS,

849: l_status varchar2(1);
850: CURSOR c1 IS
851: SELECT distinct 'Y'
852: FROM okc_k_headers_b CHR,
853: okc_statuses_b STS,
854: okc_operation_lines OLI1,
855: okc_operation_lines OLI2,
856: okc_operation_instances OIE1, --**
857: okc_class_operations COP1, --**

Line 883: okc_statuses_b STS,

879: CURSOR c2 IS
880: SELECT distinct 'Y'
881: FROM okc_k_headers_b CHR,
882: okc_k_lines_b CLE,
883: okc_statuses_b STS,
884: okc_operation_lines OLI1,
885: okc_operation_lines OLI2,
886: okc_operation_instances OIE1, --**
887: okc_class_operations COP1, --**

Line 939: okc_statuses_b STS,

935: --
936: CURSOR c1 IS
937: SELECT distinct 'Y'
938: FROM okc_k_headers_b CHR,
939: okc_statuses_b STS,
940: okc_operation_lines OLI1,
941: okc_operation_lines OLI2,
942: okc_operation_instances OIE1, --**
943: okc_class_operations COP1, --**

Line 969: okc_statuses_b STS,

965: CURSOR c2 IS
966: SELECT distinct 'Y'
967: FROM okc_k_headers_b CHR,
968: okc_k_lines_b CLE,
969: okc_statuses_b STS,
970: okc_operation_lines OLI1,
971: okc_operation_lines OLI2,
972: okc_operation_instances OIE1, --**
973: okc_class_operations COP1, --**

Line 1291: from okc_statuses_b

1287: where L.dnz_chr_id = p_id
1288: and (L.id = p_cle_id or
1289: L.cle_id = p_cle_id)
1290: and EXISTS (select 'x'
1291: from okc_statuses_b
1292: where code = l.sts_code
1293: and ste_code = 'CANCELLED')
1294: and NVL(L.term_cancel_source,'MANUAL') NOT IN ('IBTRANSFER', 'IBRETURN', 'IBTERMINATE', 'IBREPLACE'); --To ignore lines/sublines due to IBTRANSFER, IBRETURN, IBTERMINATE, IBREPLACE
1295:

Line 1304: from OKC_STATUSES_B

1300: where L.dnz_chr_id = p_id
1301: and (L.id = p_cle_id or
1302: L.cle_id = p_cle_id)
1303: and EXISTS( select 'x'
1304: from OKC_STATUSES_B
1305: where code = l.sts_code
1306: and ste_code = l_old_type)
1307: and NVL(L.term_cancel_source,'MANUAL') NOT IN ('IBTRANSFER', 'IBRETURN', 'IBTERMINATE', 'IBREPLACE'); --To ignore lines/sublines due to IBTRANSFER, IBRETURN, IBTERMINATE, IBREPLACE
1308:

Line 1760: Select ste_code from okc_statuses_b where code = p_code;

1756: l_allowed_status Varchar2(1) := 'N';
1757: l_api_name Varchar2(100) := 'Check_Allowed_Status';
1758:
1759: cursor get_ste_code(p_code in varchar2) is
1760: Select ste_code from okc_statuses_b where code = p_code;
1761:
1762: cursor get_k_hdr_cur (p_id in number) is
1763: Select sts_code, start_date, end_date from okc_k_headers_b where id = p_id;
1764: