DBA Data[Home] [Help]

APPS.OKS_ATTR_DEFAULTS_PVT dependencies on OKC_K_HEADERS_B

Line 66: FROM OKC_K_HEADERS_B

62:
63: CURSOR L_GET_HDR_DATES_CSR(P_HDR_ID IN NUMBER ) IS
64: SELECT TRUNC(START_DATE) START_DATE
65: , TRUNC(END_DATE) END_DATE
66: FROM OKC_K_HEADERS_B
67: WHERE ID = P_HDR_ID ;
68:
69: L_GET_HDR_DATES_REC L_GET_HDR_DATES_CSR%ROWTYPE;
70:

Line 294: Select SCS_CODE from OKC_K_HEADERS_B

290: WHERE object1_id1= l_party_id
291: and dnz_chr_id = p_dnz_chr_id;
292:
293: Cursor get_contract_type IS
294: Select SCS_CODE from OKC_K_HEADERS_B
295: where id = p_dnz_chr_id;
296:
297:
298: role_csr_Rec role_csr%rowtype;

Line 309: l_type OKC_K_HEADERS_B.SCS_CODE%TYPE;

305:
306: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
307: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;
308:
309: l_type OKC_K_HEADERS_B.SCS_CODE%TYPE;
310: l_rle_code VARCHAR2(2000);
311: BEGIN
312: l_can_id := p_can_id;
313: OPEN get_party(l_can_id) ;

Line 471: from okc_k_headers_b

467: authoring_org_id,
468: -- BANK ACCOUNT CONSOLIDATION --
469: price_list_id, -- hkamdar 8/23/05 R12 Partial Period
470: currency_code -- gchadha for Partial Period
471: from okc_k_headers_b
472: where id = p_chr_id;
473: l_okc_headers_rec cur_okc_headers%ROWTYPE;
474:
475: Cursor cur_okc_lines(p_cle_id in NUMBER) is