4277: and line.customer_trx_line_id = tax.link_to_cust_trx_line_id (+)
4278: order by line_number;
4279:
4280: cursor gt_lines_cur (p_cust_trx_id in number) is
4281: select * from ar_llca_trx_lines_gt
4282: where customer_trx_id = p_cust_trx_id;
4283:
4284: ll_msg_data varchar2(2000);
4285: ll_return_status varchar2(1);
4487: END IF;
4488:
4489: select count(*)
4490: into l_gt_count
4491: from ar_llca_trx_lines_gt
4492: where customer_trx_id = p_customer_trx_id
4493: and rownum = 1;
4494:
4495: -- All Lines
4754: arp_util.debug('l_calc_tax_amount -> '||to_char(l_calc_tax_amount));
4755: arp_util.debug('l_cr_unapp_bal (R) => '||to_char(l_cr_unapp_bal));
4756: END IF;
4757: --- End If;
4758: --bug7311231, Picking the flexfield value from ar_llca_trx_lines_gt, for each line.
4759: ar_activity_details_pkg.insert_row(
4760: x_rowid => l_rowid,
4761: x_cash_receipt_id => p_cash_receipt_id,
4762: x_customer_trx_line_id => sp_lines_row.customer_trx_line_id,