APPS.OKC_CTC_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 60: FROM okc_k_headers_all_b,okc_statuses_b

56: x_return_status OUT NOCOPY VARCHAR2) IS
57:
58: CURSOR c_get_contract_status(p_chr_id IN NUMBER) IS
59: SELECT ste_code
60: FROM okc_k_headers_all_b,okc_statuses_b
61: WHERE id= p_chr_id AND okc_statuses_b.code=okc_k_headers_all_b.sts_code;
62:
63: l_ste_code varchar2(30);
64:

Line 61: WHERE id= p_chr_id AND okc_statuses_b.code=okc_k_headers_all_b.sts_code;

57:
58: CURSOR c_get_contract_status(p_chr_id IN NUMBER) IS
59: SELECT ste_code
60: FROM okc_k_headers_all_b,okc_statuses_b
61: WHERE id= p_chr_id AND okc_statuses_b.code=okc_k_headers_all_b.sts_code;
62:
63: l_ste_code varchar2(30);
64:
65: BEGIN

Line 634: ,okc_k_headers_all_b KH -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b KH

630: select '!'
631: from
632: okc_k_party_roles_b PR
633: ,okc_contact_sources CS
634: ,okc_k_headers_all_b KH -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b KH
635: where
636: PR.ID = p_ctcv_rec.CPL_ID
637: and CS.CRO_CODE = p_ctcv_rec.CRO_CODE
638: and CS.RLE_CODE = PR.RLE_CODE

Line 734: ,okc_k_headers_all_b KH -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b KH

730: ,KH.SCS_CODE
731: from
732: okc_k_party_roles_b PR
733: ,okc_contact_sources CS
734: ,okc_k_headers_all_b KH -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b KH
735: where
736: PR.ID = p_ctcv_rec.CPL_ID
737: and CS.CRO_CODE = p_ctcv_rec.CRO_CODE
738: and CS.RLE_CODE = PR.RLE_CODE

Line 1075: from okc_k_headers_all_b -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b

1071: p_ctcv_rec IN CTCV_REC_TYPE) is
1072: l_dummy varchar2(1) := '?';
1073: cursor Kt_Hr_Mj_Vr is
1074: select '!'
1075: from okc_k_headers_all_b -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b
1076: where id = p_ctcv_rec.dnz_chr_id;
1077: begin
1078:
1079: IF (l_debug = 'Y') THEN

Line 1440: From okc_k_headers_all_b --Modified by Jvorugan for Bug:4645341 okc_k_headers_b

1436: l_access_level varchar2(1);
1437:
1438: Cursor c_buy_or_sell Is
1439: Select buy_or_sell
1440: From okc_k_headers_all_b --Modified by Jvorugan for Bug:4645341 okc_k_headers_b
1441: Where id = p_ctcv_rec.dnz_chr_id;
1442:
1443: Cursor c_rle_code Is
1444: Select rle_code

Line 2753: FROM okc_k_headers_all_b KH,okc_statuses_b STB

2749: l_ste_code VARCHAR2(30);
2750:
2751: CURSOR get_k_status(p_chr_id IN NUMBER) IS
2752: SELECT ste_code
2753: FROM okc_k_headers_all_b KH,okc_statuses_b STB
2754: WHERE KH.sts_code = STB.code
2755: AND id= p_chr_id;
2756:
2757: /*added for bug 6882512*/

Line 3888: FROM okc_k_headers_all_b KH,okc_statuses_b STB

3884: j number;
3885: /*added for bug 6882512*/
3886: CURSOR get_k_status(p_chr_id IN NUMBER) IS
3887: SELECT ste_code
3888: FROM okc_k_headers_all_b KH,okc_statuses_b STB
3889: WHERE KH.sts_code = STB.code
3890: AND id= p_chr_id;
3891: /*added for bug 6882512*/
3892: