APPS.OKS_CHANGE_STATUS_PVT dependencies on OKC_K_HEADERS_B

Line 575: FROM okc_k_headers_b

571: CURSOR c_obj_ver(p_id NUMBER) IS
572: SELECT object_version_number, decode(
573: NVL(sign(months_between(START_DATE,sysdate+1)),1),-1,decode(
574: NVL(sign(months_between(END_DATE,sysdate-1)),1),1,'ACTIVE','EXPIRED'),'SIGNED' )
575: FROM okc_k_headers_b
576: WHERE id = p_id;
577: BEGIN
578: x_chrv_tbl(i).VALIDATE_YN := 'N';
579: Open c_obj_ver(x_chrv_tbl(i).id);

Line 724: from okc_k_headers_b CHR,

720: -- building a list of source contract for the renewed contract being resurrected
721: cursor C1 is
722: select distinct contract_number, contract_number_modifier,
723: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contracts
724: from okc_k_headers_b CHR,
725: okc_operation_lines OLI,
726: okc_operation_instances OIE, --**
727: okc_class_operations COP --**
728: where OLI.subject_chr_id = l_chr_id

Line 740: from okc_k_headers_b CHR,

736:
737: Cursor C2 is
738: select contract_number, contract_number_modifier,
739: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contracts
740: from okc_k_headers_b CHR,
741: okc_operation_lines OLI,
742: okc_operation_instances OIE, --**
743: okc_class_operations COP --**
744: where OLI.subject_chr_id = l_chr_id

Line 773: FROM okc_k_headers_b CHR,

769: -- building list of target contracts for the same source contracts
770: CURSOR C1 IS
771: SELECT distinct contract_number, contract_number_modifier,
772: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contracts
773: FROM okc_k_headers_b CHR,
774: okc_operation_lines OLI1,
775: okc_operation_lines OLI2,
776: okc_operation_instances OIE1,
777: okc_class_operations COP1,

Line 797: FROM okc_k_headers_b CHR,

793: -- Line Level Check added as part of LLC
794: CURSOR C2 is
795: SELECT contract_number, contract_number_modifier,
796: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contracts
797: FROM okc_k_headers_b CHR,
798: okc_k_lines_b CLE,
799: okc_statuses_b STE,
800: okc_operation_lines OLI1,
801: okc_operation_lines OLI2,

Line 850: from OKC_K_HEADERS_B CHR,

846: -- CANCELLED status (DATE_RENEWED is NULL).
847: --
848: cursor c1 is
849: select distinct 'Y'
850: from OKC_K_HEADERS_B CHR,
851: okc_operation_lines OLI,
852: okc_operation_instances OIE,
853: okc_class_operations COP
854: where chr.id = oli.object_chr_id

Line 895: FROM okc_k_headers_b CHR,

891: l_chr_id number := p_id;
892: l_status varchar2(1);
893: CURSOR c1 IS
894: SELECT distinct 'Y'
895: FROM okc_k_headers_b CHR,
896: okc_statuses_b STS,
897: okc_operation_lines OLI1,
898: okc_operation_lines OLI2,
899: okc_operation_instances OIE1, --**

Line 924: FROM okc_k_headers_b CHR,

920: -- Line Level Check added as part of LLC
921:
922: CURSOR c2 IS
923: SELECT distinct 'Y'
924: FROM okc_k_headers_b CHR,
925: okc_k_lines_b CLE,
926: okc_statuses_b STS,
927: okc_operation_lines OLI1,
928: okc_operation_lines OLI2,

Line 981: FROM okc_k_headers_b CHR,

977: --
978: --
979: CURSOR c1 IS
980: SELECT distinct 'Y'
981: FROM okc_k_headers_b CHR,
982: okc_statuses_b STS,
983: okc_operation_lines OLI1,
984: okc_operation_lines OLI2,
985: okc_operation_instances OIE1, --**

Line 1010: FROM okc_k_headers_b CHR,

1006: -- Line Level Check added as part of LLC
1007:
1008: CURSOR c2 IS
1009: SELECT distinct 'Y'
1010: FROM okc_k_headers_b CHR,
1011: okc_k_lines_b CLE,
1012: okc_statuses_b STS,
1013: okc_operation_lines OLI1,
1014: okc_operation_lines OLI2,

Line 1219: FROM okc_k_headers_b

1215: --
1216:
1217: CURSOR get_scs_code_csr IS
1218: SELECT scs_code
1219: FROM okc_k_headers_b
1220: WHERE id= p_id;
1221:
1222: --
1223:

Line 1817: Select sts_code, start_date, end_date from okc_k_headers_b where id = p_id;

1813: cursor get_ste_code(p_code in varchar2) is
1814: Select ste_code from okc_statuses_b where code = p_code;
1815:
1816: cursor get_k_hdr_cur (p_id in number) is
1817: Select sts_code, start_date, end_date from okc_k_headers_b where id = p_id;
1818:
1819: cursor get_k_line_cur(p_cle_id in number) is
1820: Select sts_code, start_date, end_date from okc_k_lines_b where id = p_id;
1821: