APPS.OKL_ACCOUNTING_UTIL dependencies on OKL_SYSTEM_PARAMS_ALL

Line 3188: l_fa_reporting_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;

3184: -- MGAAP 7263041
3185: FUNCTION get_fa_reporting_book( p_org_id NUMBER DEFAULT NULL)
3186: RETURN VARCHAR2 IS
3187: l_org_id NUMBER;
3188: l_fa_reporting_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
3189: CURSOR c_fa_reporting_book(l_org_id NUMBER) IS
3190: SELECT RPT_PROD_BOOK_TYPE_CODE
3191: FROM OKL_SYSTEM_PARAMS_ALL
3192: WHERE ORG_ID = l_org_id;

Line 3191: FROM OKL_SYSTEM_PARAMS_ALL

3187: l_org_id NUMBER;
3188: l_fa_reporting_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
3189: CURSOR c_fa_reporting_book(l_org_id NUMBER) IS
3190: SELECT RPT_PROD_BOOK_TYPE_CODE
3191: FROM OKL_SYSTEM_PARAMS_ALL
3192: WHERE ORG_ID = l_org_id;
3193: BEGIN
3194: IF (p_org_id is NULL OR
3195: p_org_id = OKL_API.G_MISS_NUM) THEN

Line 3209: l_fa_reporting_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;

3205: END get_fa_reporting_book;
3206:
3207: FUNCTION get_fa_reporting_book( p_kle_id NUMBER ) RETURN VARCHAR2 IS
3208: l_org_id NUMBER;
3209: l_fa_reporting_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
3210: CURSOR c_org_id(l_kle_id NUMBER) IS
3211: SELECT a.authoring_org_id ORG_ID
3212: FROM okc_k_headers_all_b a,
3213: okc_k_lines_b b