APPS.ARP_RECON_REP dependencies on AR_GL_RECON_GT

Line 2681: insert into ar_gl_recon_gt(code_combination_id,

2677: l_message_acct := FND_MESSAGE.Get;
2678: END IF;
2679:
2680: execute immediate '
2681: insert into ar_gl_recon_gt(code_combination_id,
2682: receivables_dr,receivables_cr,
2683: account_type, account_type_code)
2684: (select dat.code_combination_id,
2685: sum(nvl(acctd_amount_dr,0)) receivables_debit,

Line 2910: update ar_gl_recon_gt argt

2906: l_gl_date_from, l_gl_date_to,
2907: l_gl_date_from, l_gl_date_to, p_reporting_entity_id ;
2908:
2909:
2910: update ar_gl_recon_gt argt
2911: set (opening_balance_dr,
2912: opening_balance_cr,
2913: period_activity_dr,
2914: period_activity_cr) = (select nvl(glb.begin_balance_dr,0),

Line 2925: update ar_gl_recon_gt argt

2921: and glb.actual_flag = 'A'
2922: and glb.ledger_id = get_set_of_books_id()
2923: and glb.currency_code = get_functional_currency());
2924:
2925: update ar_gl_recon_gt argt
2926: set (subledger_not_ar_dr ,
2927: subledger_not_ar_cr ,
2928: subledger_manual_dr ,
2929: subledger_manual_cr ,

Line 2966: update ar_gl_recon_gt argt

2962: and gjh.actual_flag = 'A'
2963: and gjh.currency_code <> 'STAT'
2964: group by gjl.code_combination_id);
2965:
2966: update ar_gl_recon_gt argt
2967: set (gl_interface_dr, gl_interface_cr) =
2968: (select sum(nvl(gif.accounted_dr,0)) gl_interface_dr,
2969: sum(nvl(gif.accounted_cr,0)) gl_interface_cr
2970: from gl_interface gif,

Line 2979: update ar_gl_recon_gt

2975: and gjs.je_source_name = 'Receivables'
2976: and gif.actual_flag = 'A'
2977: group by gif.code_combination_id);
2978:
2979: update ar_gl_recon_gt
2980: set account = ar_calc_aging.get_value(101,'GL#',
2981: arp_recon_rep.get_chart_of_accounts_id(),'ALL',code_combination_id),
2982: company = ar_calc_aging.get_value(101,'GL#',
2983: arp_recon_rep.get_chart_of_accounts_id(),'GL_BALANCING',code_combination_id),

Line 3010: from ar_gl_recon_gt

3006: nvl(gl_interface_dr,0) gl_interface_debit,
3007: nvl(gl_interface_cr,0) gl_interface_credit,
3008: nvl(receivables_dr,0) receivables_debit,
3009: nvl(receivables_cr,0) receivables_credit
3010: from ar_gl_recon_gt
3011: where ''N'' = arp_recon_rep.get_out_of_balance_only()
3012: or nvl(receivables_dr,0)- nvl(subledger_rec_dr,0) <> 0
3013: or nvl(receivables_cr,0)- nvl(subledger_rec_cr,0) <> 0
3014: order by account_type_code,