DBA Data[Home] [Help]

APPS.OKC_CTC_PVT dependencies on OKC_K_HEADERS_ALL_B

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

573: select '!'
574: from
575: okc_k_party_roles_b PR
576: ,okc_contact_sources CS
577: ,okc_k_headers_all_b KH -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b KH
578: where
579: PR.ID = p_ctcv_rec.CPL_ID
580: and CS.CRO_CODE = p_ctcv_rec.CRO_CODE
581: and CS.RLE_CODE = PR.RLE_CODE

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

673: ,KH.SCS_CODE
674: from
675: okc_k_party_roles_b PR
676: ,okc_contact_sources CS
677: ,okc_k_headers_all_b KH -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b KH
678: where
679: PR.ID = p_ctcv_rec.CPL_ID
680: and CS.CRO_CODE = p_ctcv_rec.CRO_CODE
681: and CS.RLE_CODE = PR.RLE_CODE

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

1014: p_ctcv_rec IN CTCV_REC_TYPE) is
1015: l_dummy varchar2(1) := '?';
1016: cursor Kt_Hr_Mj_Vr is
1017: select '!'
1018: from okc_k_headers_all_b -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b
1019: where id = p_ctcv_rec.dnz_chr_id;
1020: begin
1021:
1022: IF (l_debug = 'Y') THEN

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

1379: l_access_level varchar2(1);
1380:
1381: Cursor c_buy_or_sell Is
1382: Select buy_or_sell
1383: From okc_k_headers_all_b --Modified by Jvorugan for Bug:4645341 okc_k_headers_b
1384: Where id = p_ctcv_rec.dnz_chr_id;
1385:
1386: Cursor c_rle_code Is
1387: Select rle_code