APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on AR_CCID_BY_GL_ACCOUNTS

Line 13: IS TABLE OF ar_ccid_by_gl_accounts.gl_account%TYPE

9: TYPE flex_table IS TABLE OF FND_FLEX_VALUES.flex_value%TYPE
10: INDEX BY BINARY_INTEGER;
11:
12: TYPE gl_accounts_type
13: IS TABLE OF ar_ccid_by_gl_accounts.gl_account%TYPE
14: INDEX BY BINARY_INTEGER;
15:
16: TYPE components_type
17: IS TABLE OF ar_gl_acct_balances.component%TYPE

Line 513: ', ar_ccid_by_gl_accounts glc

509: FROM ' ||
510: g_ra_cust_trx_gl_dist_all || ', ' ||
511: g_ra_customer_trx_all || ', ' ||
512: g_ra_cust_trx_types_all ||
513: ', ar_ccid_by_gl_accounts glc
514: WHERE dist.gl_date BETWEEN :p_start_date AND :p_end_date
515: AND dist.account_set_flag = ''N''
516: AND trx.complete_flag = ''Y''
517: AND dist.customer_trx_id = trx.customer_trx_id

Line 559: 'ar_ccid_by_gl_accounts glc

555: g_ar_distributions_all || ', ' ||
556: g_ar_cash_receipt_history_all || ', ' ||
557: g_ar_cash_receipts_all || ', ' ||
558: g_ar_receipt_methods || ' , ' ||
559: 'ar_ccid_by_gl_accounts glc
560: WHERE crh.gl_date between :p_start_date and :p_end_date
561: AND crh.cash_receipt_history_id = ard.source_id
562: AND ard.source_table = ''CRH''
563: AND ard.code_combination_id = glc.code_combination_id

Line 612: ' ar_ccid_by_gl_accounts glc

608: max(ard.org_id) org_id
609: FROM ' ||
610: g_ar_distributions_all || ', ' ||
611: g_ar_receivable_apps_all || ', ' ||
612: ' ar_ccid_by_gl_accounts glc
613: WHERE ra.gl_date BETWEEN :p_start_date and :p_end_date
614: AND ra.receivable_application_id = ard.source_id
615: AND ard.source_table = ''RA''
616: AND ard.code_combination_id = glc.code_combination_id '

Line 662: ' ar_ccid_by_gl_accounts glc

658: g_ar_distributions_all || ', ' ||
659: g_ar_misc_cash_dists_all || ', ' ||
660: g_ar_cash_receipts_all || ', ' ||
661: g_ar_receipt_methods || ', ' ||
662: ' ar_ccid_by_gl_accounts glc
663: WHERE mcd.gl_date between :p_start_date and :p_end_date
664: AND mcd.misc_cash_distribution_id = ard.source_id
665: AND ard.source_table = ''MCD''
666: AND ard.code_combination_id = glc.code_combination_id

Line 715: ' ar_ccid_by_gl_accounts glc

711: g_ar_distributions_all || ', ' ||
712: g_ar_adjustments_all || ', ' ||
713: g_ra_customer_trx_all || ', ' ||
714: g_ra_cust_trx_types_all || ', ' ||
715: ' ar_ccid_by_gl_accounts glc
716: WHERE adj.gl_date between :p_start_date and :p_end_date
717: AND adj.adjustment_id = ard.source_id
718: AND ard.source_table = ''ADJ''
719: AND ard.code_combination_id = glc.code_combination_id

Line 765: ' ar_ccid_by_gl_accounts glc

761: max(ard.org_id) org_id
762: FROM ' ||
763: g_ar_distributions_all || ', ' ||
764: g_ar_transaction_history_all || ', ' ||
765: ' ar_ccid_by_gl_accounts glc
766: WHERE br.gl_date between :p_start_date and :p_end_date
767: AND br.transaction_history_id = ard.source_id
768: AND ard.source_table = ''TH''
769: AND ard.code_combination_id = glc.code_combination_id '

Line 1130: DELETE FROM ar_ccid_by_gl_accounts;

1126: l_segment_name := get_gl_account_segment();
1127:
1128: debug('Natural segment: ' || l_segment_name);
1129:
1130: DELETE FROM ar_ccid_by_gl_accounts;
1131:
1132: debug('number of rows deleted: ' || SQL%ROWCOUNT);
1133:
1134: l_sql_stmt :=

Line 1135: 'INSERT INTO ar_ccid_by_gl_accounts

1131:
1132: debug('number of rows deleted: ' || SQL%ROWCOUNT);
1133:
1134: l_sql_stmt :=
1135: 'INSERT INTO ar_ccid_by_gl_accounts
1136: (
1137: code_combination_id,
1138: natural_account,
1139: gl_account,