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 1161: FROM gl_code_combinations gcc

1157: ' || l_user_id || ' ,
1158: sysdate,
1159: ' || l_user_id || ' ,
1160: ' || l_user_id || '
1161: FROM gl_code_combinations gcc
1162: WHERE gcc.account_type IN (''A'', ''L'')
1163: AND chart_of_accounts_id = ' || p_chart_of_accounts_id || '
1164: AND ' || l_segment_name || ' IS NOT NULL ) ';
1165:

Line 1838: gl_code_combinations gcc

1834: decode(sign(sum(nvl(amount_cr,0))-sum(nvl(amount_dr,0))), -1, 0,
1835: sum(nvl(amount_cr,0))-sum(nvl(amount_dr,0)))
1836: amount_cr
1837: FROM ar_base_gl_acct_balances bal,
1838: gl_code_combinations gcc
1839: WHERE bal.code_combination_id = gcc.code_combination_id ';
1840:
1841: l_recent_query :=
1842: 'SELECT

Line 1865: gl_code_combinations gcc

1861: decode(sign(sum(nvl(amount_cr,0))-sum(nvl(amount_dr,0))), -1, 0,
1862: sum(nvl(amount_cr,0))-sum(nvl(amount_dr,0)))
1863: amount_cr
1864: FROM ar_gl_acct_balances bal,
1865: gl_code_combinations gcc
1866: WHERE bal.code_combination_id = gcc.code_combination_id ';
1867:
1868: -- l_dummy_where := ' WHERE 1=1 ';
1869: l_group_by := ' GROUP BY gl_account, natural_account, trx_type,