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 2371: OKC_K_HEADERS_B hdr,

2367: rhdr.exempt_reason_code
2368: --End fixes of eBtax uptake bug#4756579
2369: FROM
2370: OKS_K_HEADERS_B rhdr,
2371: OKC_K_HEADERS_B hdr,
2372: OKS_K_LINES_B line
2373: WHERE line.cle_id = p_cle_id
2374: AND hdr.id = line.dnz_chr_id
2375: AND hdr.id = rhdr.chr_id;

Line 2549: From OKC_K_HEADERS_B

2545: ,attribute13
2546: ,attribute14
2547: ,attribute15
2548: ,attribute_category
2549: From OKC_K_HEADERS_B
2550: Where id = p_id;
2551:
2552: --mchoudha Bug#3676706
2553: --changed the condition from trunc(bcl.date_billed_from) = trunc(p_date_from)