DBA Data[Home] [Help]

APPS.OKS_ARFEEDER_PUB dependencies on OKC_K_HEADERS_B

Line 32: SELECT Authoring_Org_Id FROM OKC_K_HEADERS_B

28:
29: Function get_authoring_org_id (p_chrid NUMBER) Return NUMBER Is
30:
31: Cursor l_hdrs_csr Is
32: SELECT Authoring_Org_Id FROM OKC_K_HEADERS_B
33: WHERE id = p_chrid;
34:
35: l_orgid NUMBER;
36: BEGIN

Line 67: SELECT Org_Id FROM OKC_K_HEADERS_B

63:
64: Function get_organization_id (p_chrid NUMBER) Return NUMBER Is
65:
66: Cursor l_hdrs_csr Is
67: SELECT Org_Id FROM OKC_K_HEADERS_B
68: WHERE id = p_chrid;
69:
70: l_orgid NUMBER;
71: l_organization_id NUMBER;

Line 102: Cursor l_hdrs_csr Is Select Org_Id From OKC_K_HEADERS_B

98: END get_acct_calender;
99:
100: Function get_set_of_books_id (p_chrid NUMBER) Return NUMBER Is
101:
102: Cursor l_hdrs_csr Is Select Org_Id From OKC_K_HEADERS_B
103: Where id = p_chrid;
104:
105: Cursor l_org_csr (p_org_id NUMBER) Is
106: SELECT OI2.ORG_INFORMATION3 set_of_books_id

Line 2390: OKC_K_HEADERS_B hdr,

2386: rhdr.exempt_reason_code
2387: --End fixes of eBtax uptake bug#4756579
2388: FROM
2389: OKS_K_HEADERS_B rhdr,
2390: OKC_K_HEADERS_B hdr,
2391: OKS_K_LINES_B line
2392: WHERE line.cle_id = p_cle_id
2393: AND hdr.id = line.dnz_chr_id
2394: AND hdr.id = rhdr.chr_id;

Line 2568: From OKC_K_HEADERS_B

2564: ,attribute13
2565: ,attribute14
2566: ,attribute15
2567: ,attribute_category
2568: From OKC_K_HEADERS_B
2569: Where id = p_id;
2570:
2571: --mchoudha Bug#3676706
2572: --changed the condition from trunc(bcl.date_billed_from) = trunc(p_date_from)