APPS.ARP_BALANCE_CHECK dependencies on RA_CUSTOMER_TRX

Line 37: from ra_customer_trx_lines ctl

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

Line 50: l_customer_rec ra_customer_trx%ROWTYPE;

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

Line 72: FROM ra_batch_sources ra, ra_customer_trx rt

68: SELECT NVL(gen_line_level_bal_flag,'N'),
69: NVL(rt.complete_flag,'N')
70: INTO l_gen_line_level_bal_flag,
71: l_complete_flag_db
72: FROM ra_batch_sources ra, ra_customer_trx rt
73: WHERE ra.batch_source_id = rt.batch_source_id
74: AND rt.customer_trx_id = p_customer_trx_id;
75:
76: arp_standard.debug('old_complete_flag: '||ARP_PROCESS_HEADER_UPDTE_COVER.g_old_complete_flag);

Line 1312: ra_customer_trx ct,

1308: CURSOR C1(p_cust_trx_id NUMBER) IS
1309: select 'X'
1310: from ar_payment_schedules ps,
1311: ra_cust_trx_line_gl_dist gld,
1312: ra_customer_trx ct,
1313: (select customer_trx_id,
1314: sum(amount_due_remaining + nvl(chrg_amount_remaining, 0) + nvl(frt_adj_remaining, 0)) amount_due_remaining,
1315: sum(acctd_amount_due_remaining + nvl(chrg_acctd_amount_remaining, 0) + nvl(frt_adj_acctd_remaining, 0)) acctd_amount_due_remaining
1316: from ra_customer_trx_lines

Line 1316: from ra_customer_trx_lines

1312: ra_customer_trx ct,
1313: (select customer_trx_id,
1314: sum(amount_due_remaining + nvl(chrg_amount_remaining, 0) + nvl(frt_adj_remaining, 0)) amount_due_remaining,
1315: sum(acctd_amount_due_remaining + nvl(chrg_acctd_amount_remaining, 0) + nvl(frt_adj_acctd_remaining, 0)) acctd_amount_due_remaining
1316: from ra_customer_trx_lines
1317: where customer_trx_id=decode(p_customer_trx_id,0,customer_trx_id,p_customer_trx_id)
1318: GROUP BY customer_trx_id) a
1319: where ct.upgrade_method='R12'
1320: and ct.customer_trx_id=decode(p_customer_trx_id,0,ct.customer_trx_id,p_customer_trx_id)

Line 1338: l_customer_rec ra_customer_trx%ROWTYPE;

1334: -- OKL LLCA Bug 6129910
1335: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1336: l_msg_data VARCHAR2(2000);
1337: l_msg_count NUMBER;
1338: l_customer_rec ra_customer_trx%ROWTYPE;
1339: l_gen_line_level_bal_flag VARCHAR(1) := 'N';
1340: l_complete_flag_db varchar2(1) := 'N';
1341: excep_set_org_rem_amt_r12 EXCEPTION;
1342: