APPS.ARP_CTL_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 142: (select sum(ctl_tax.extended_amount) from ra_customer_trx_lines_all ctl_tax

138: IF p_mode = 'INSERT_NO_LINE' then
139:
140: select sum(decode(ct.complete_flag , 'N', 0,
141: nvl(ctl.tax_recoverable,
142: (select sum(ctl_tax.extended_amount) from ra_customer_trx_lines_all ctl_tax
143: where ctl_tax.customer_trx_id = ctl.customer_trx_id
144: and ctl_tax.link_to_cust_trx_line_id = ctl.customer_trx_line_id
145: and ctl_tax.line_type = 'TAX')))) tax_recoverable
146: INTO l_tax_recoverable

Line 147: from ra_customer_trx_lines_all orig_ctl,

143: where ctl_tax.customer_trx_id = ctl.customer_trx_id
144: and ctl_tax.link_to_cust_trx_line_id = ctl.customer_trx_line_id
145: and ctl_tax.line_type = 'TAX')))) tax_recoverable
146: INTO l_tax_recoverable
147: from ra_customer_trx_lines_all orig_ctl,
148: ra_customer_trx_lines_all ctl,
149: ra_customer_trx_lines_all cm_ctl,
150: ra_customer_trx_all ct
151: where (ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id

Line 148: ra_customer_trx_lines_all ctl,

144: and ctl_tax.link_to_cust_trx_line_id = ctl.customer_trx_line_id
145: and ctl_tax.line_type = 'TAX')))) tax_recoverable
146: INTO l_tax_recoverable
147: from ra_customer_trx_lines_all orig_ctl,
148: ra_customer_trx_lines_all ctl,
149: ra_customer_trx_lines_all cm_ctl,
150: ra_customer_trx_all ct
151: where (ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id
152: OR ( ctl.previous_customer_trx_line_id IS NOT NULL

Line 149: ra_customer_trx_lines_all cm_ctl,

145: and ctl_tax.line_type = 'TAX')))) tax_recoverable
146: INTO l_tax_recoverable
147: from ra_customer_trx_lines_all orig_ctl,
148: ra_customer_trx_lines_all ctl,
149: ra_customer_trx_lines_all cm_ctl,
150: ra_customer_trx_all ct
151: where (ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id
152: OR ( ctl.previous_customer_trx_line_id IS NOT NULL
153: AND ctl.previous_customer_trx_line_id = orig_ctl.customer_trx_line_id)

Line 164: nvl(ctl.tax_recoverable, (select sum(ctl_tax.extended_amount) from ra_customer_trx_lines_all ctl_tax

160: and ct.customer_trx_id = ctl.customer_trx_id
161: group by orig_ctl.customer_trx_line_id, ctl.line_type;
162:
163: select sum(decode(ct.complete_flag , 'N', 0,
164: nvl(ctl.tax_recoverable, (select sum(ctl_tax.extended_amount) from ra_customer_trx_lines_all ctl_tax
165: where ctl_tax.customer_trx_id = ctl.customer_trx_id
166: and ctl_tax.link_to_cust_trx_line_id = ctl.customer_trx_line_id
167: and ctl_tax.line_type = 'TAX')))) total_tax_recoverable
168: INTO l_total_tax_recoverable

Line 169: from ra_customer_trx_lines_all orig_ctl,

165: where ctl_tax.customer_trx_id = ctl.customer_trx_id
166: and ctl_tax.link_to_cust_trx_line_id = ctl.customer_trx_line_id
167: and ctl_tax.line_type = 'TAX')))) total_tax_recoverable
168: INTO l_total_tax_recoverable
169: from ra_customer_trx_lines_all orig_ctl,
170: ra_customer_trx_lines_all ctl,
171: ra_customer_trx_lines_all cm_ctl,
172: ra_customer_trx_all ct
173: where (ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id

Line 170: ra_customer_trx_lines_all ctl,

166: and ctl_tax.link_to_cust_trx_line_id = ctl.customer_trx_line_id
167: and ctl_tax.line_type = 'TAX')))) total_tax_recoverable
168: INTO l_total_tax_recoverable
169: from ra_customer_trx_lines_all orig_ctl,
170: ra_customer_trx_lines_all ctl,
171: ra_customer_trx_lines_all cm_ctl,
172: ra_customer_trx_all ct
173: where (ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id
174: OR ( ctl.previous_customer_trx_line_id IS NOT NULL

Line 171: ra_customer_trx_lines_all cm_ctl,

167: and ctl_tax.line_type = 'TAX')))) total_tax_recoverable
168: INTO l_total_tax_recoverable
169: from ra_customer_trx_lines_all orig_ctl,
170: ra_customer_trx_lines_all ctl,
171: ra_customer_trx_lines_all cm_ctl,
172: ra_customer_trx_all ct
173: where (ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id
174: OR ( ctl.previous_customer_trx_line_id IS NOT NULL
175: AND ctl.previous_customer_trx_line_id = orig_ctl.customer_trx_line_id)