APPS.OKL_ACCOUNTING_UTIL dependencies on OKL_SYSTEM_PARAMS_ALL

Line 3186: l_fa_reporting_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;

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

Line 3189: FROM OKL_SYSTEM_PARAMS_ALL

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

Line 3207: l_fa_reporting_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;

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