APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on GL_CODE_COMBINATIONS

Line 21: IS TABLE OF gl_code_combinations.segment1%TYPE

17: IS TABLE OF ar_gl_acct_balances.component%TYPE
18: INDEX BY BINARY_INTEGER;
19:
20: TYPE natural_accounts_type
21: IS TABLE OF gl_code_combinations.segment1%TYPE
22: INDEX BY BINARY_INTEGER;
23:
24: TYPE trx_type_type
25: IS TABLE OF ar_receipt_methods.name%TYPE

Line 1188: FROM gl_code_combinations gcc

1184: ' || l_user_id || ' ,
1185: sysdate,
1186: ' || l_user_id || ' ,
1187: ' || l_user_id || '
1188: FROM gl_code_combinations gcc
1189: WHERE gcc.account_type IN (''A'', ''L'')
1190: AND chart_of_accounts_id = ' || p_chart_of_accounts_id || '
1191: AND ' || l_segment_name || ' IS NOT NULL ) ';
1192:

Line 1867: gl_code_combinations gcc

1863: decode(sign(sum(nvl(amount_cr,0))-sum(nvl(amount_dr,0))), -1, 0,
1864: sum(nvl(amount_cr,0))-sum(nvl(amount_dr,0)))
1865: amount_cr
1866: FROM ar_base_gl_acct_balances bal,
1867: gl_code_combinations gcc
1868: WHERE bal.code_combination_id = gcc.code_combination_id ';
1869:
1870: l_recent_query :=
1871: 'SELECT

Line 1894: gl_code_combinations gcc

1890: decode(sign(sum(nvl(amount_cr,0))-sum(nvl(amount_dr,0))), -1, 0,
1891: sum(nvl(amount_cr,0))-sum(nvl(amount_dr,0)))
1892: amount_cr
1893: FROM ar_gl_acct_balances bal,
1894: gl_code_combinations gcc
1895: WHERE bal.code_combination_id = gcc.code_combination_id ';
1896:
1897: -- l_dummy_where := ' WHERE 1=1 ';
1898: l_group_by := ' GROUP BY gl_account, natural_account, trx_type,