APPS.ARP_BALANCE_CHECK dependencies on RA_CUSTOMER_TRX

Line 36: from ra_customer_trx_lines ctl

32: where ctlgd.customer_trx_id = p_cust_trx_id
33: and ctlgd.account_set_flag = 'N'
34: and ctlgd.posting_control_id = -3
35: and not exists (select 'x'
36: from ra_customer_trx_lines ctl
37: where ctl.customer_trx_id = p_customer_trx_id
38: and ctl.autorule_complete_flag||'' = 'N'
39: group by ctl.customer_trx_id)
40: group by customer_trx_id, gl_date;

Line 49: l_customer_rec ra_customer_trx%ROWTYPE;

45: -- OKL LLCA Bug 6125678
46: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
47: l_msg_data VARCHAR2(2000);
48: l_msg_count NUMBER;
49: l_customer_rec ra_customer_trx%ROWTYPE;
50: l_gen_line_level_bal_flag VARCHAR(1) := 'N';
51: excep_set_org_rem_amt_r12 EXCEPTION;
52:
53:

Line 68: FROM ra_batch_sources ra, ra_customer_trx rt

64: -- Check the batch source flag
65:
66: SELECT NVL(gen_line_level_bal_flag,'N')
67: INTO l_gen_line_level_bal_flag
68: FROM ra_batch_sources ra, ra_customer_trx rt
69: WHERE ra.batch_source_id = rt.batch_source_id
70: AND rt.customer_trx_id = p_customer_trx_id;
71:
72: IF l_gen_line_level_bal_flag = 'Y' THEN