12: p_tax_remaining OUT NOCOPY ar_payment_schedules.tax_remaining%type,
13: p_tax_remaining_db OUT NOCOPY ar_payment_schedules.tax_remaining%type,
14: p_freight_remaining OUT NOCOPY ar_payment_schedules.freight_remaining%type,
15: p_freight_remaining_db OUT NOCOPY ar_payment_schedules.freight_remaining%type,
16: p_line_credited OUT NOCOPY ar_receivable_applications.line_applied%type,
17: p_line_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
18: p_charges_credited OUT NOCOPY ar_receivable_applications.line_applied%type,
19: p_charges_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
20: p_tax_credited OUT NOCOPY ar_receivable_applications.tax_applied%type,
13: p_tax_remaining_db OUT NOCOPY ar_payment_schedules.tax_remaining%type,
14: p_freight_remaining OUT NOCOPY ar_payment_schedules.freight_remaining%type,
15: p_freight_remaining_db OUT NOCOPY ar_payment_schedules.freight_remaining%type,
16: p_line_credited OUT NOCOPY ar_receivable_applications.line_applied%type,
17: p_line_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
18: p_charges_credited OUT NOCOPY ar_receivable_applications.line_applied%type,
19: p_charges_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
20: p_tax_credited OUT NOCOPY ar_receivable_applications.tax_applied%type,
21: p_tax_credited_db OUT NOCOPY ar_receivable_applications.tax_applied%type,
14: p_freight_remaining OUT NOCOPY ar_payment_schedules.freight_remaining%type,
15: p_freight_remaining_db OUT NOCOPY ar_payment_schedules.freight_remaining%type,
16: p_line_credited OUT NOCOPY ar_receivable_applications.line_applied%type,
17: p_line_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
18: p_charges_credited OUT NOCOPY ar_receivable_applications.line_applied%type,
19: p_charges_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
20: p_tax_credited OUT NOCOPY ar_receivable_applications.tax_applied%type,
21: p_tax_credited_db OUT NOCOPY ar_receivable_applications.tax_applied%type,
22: p_freight_credited OUT NOCOPY ar_receivable_applications.freight_applied%type,
15: p_freight_remaining_db OUT NOCOPY ar_payment_schedules.freight_remaining%type,
16: p_line_credited OUT NOCOPY ar_receivable_applications.line_applied%type,
17: p_line_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
18: p_charges_credited OUT NOCOPY ar_receivable_applications.line_applied%type,
19: p_charges_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
20: p_tax_credited OUT NOCOPY ar_receivable_applications.tax_applied%type,
21: p_tax_credited_db OUT NOCOPY ar_receivable_applications.tax_applied%type,
22: p_freight_credited OUT NOCOPY ar_receivable_applications.freight_applied%type,
23: p_freight_credited_db OUT NOCOPY ar_receivable_applications.freight_applied%type)
16: p_line_credited OUT NOCOPY ar_receivable_applications.line_applied%type,
17: p_line_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
18: p_charges_credited OUT NOCOPY ar_receivable_applications.line_applied%type,
19: p_charges_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
20: p_tax_credited OUT NOCOPY ar_receivable_applications.tax_applied%type,
21: p_tax_credited_db OUT NOCOPY ar_receivable_applications.tax_applied%type,
22: p_freight_credited OUT NOCOPY ar_receivable_applications.freight_applied%type,
23: p_freight_credited_db OUT NOCOPY ar_receivable_applications.freight_applied%type)
24: IS
17: p_line_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
18: p_charges_credited OUT NOCOPY ar_receivable_applications.line_applied%type,
19: p_charges_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
20: p_tax_credited OUT NOCOPY ar_receivable_applications.tax_applied%type,
21: p_tax_credited_db OUT NOCOPY ar_receivable_applications.tax_applied%type,
22: p_freight_credited OUT NOCOPY ar_receivable_applications.freight_applied%type,
23: p_freight_credited_db OUT NOCOPY ar_receivable_applications.freight_applied%type)
24: IS
25: BEGIN
18: p_charges_credited OUT NOCOPY ar_receivable_applications.line_applied%type,
19: p_charges_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
20: p_tax_credited OUT NOCOPY ar_receivable_applications.tax_applied%type,
21: p_tax_credited_db OUT NOCOPY ar_receivable_applications.tax_applied%type,
22: p_freight_credited OUT NOCOPY ar_receivable_applications.freight_applied%type,
23: p_freight_credited_db OUT NOCOPY ar_receivable_applications.freight_applied%type)
24: IS
25: BEGIN
26: arp_util.debug('arp_inst_util_pkg.select_inst_summary()+');
19: p_charges_credited_db OUT NOCOPY ar_receivable_applications.line_applied%type,
20: p_tax_credited OUT NOCOPY ar_receivable_applications.tax_applied%type,
21: p_tax_credited_db OUT NOCOPY ar_receivable_applications.tax_applied%type,
22: p_freight_credited OUT NOCOPY ar_receivable_applications.freight_applied%type,
23: p_freight_credited_db OUT NOCOPY ar_receivable_applications.freight_applied%type)
24: IS
25: BEGIN
26: arp_util.debug('arp_inst_util_pkg.select_inst_summary()+');
27:
66: p_line_credited_db,
67: p_charges_credited_db,
68: p_tax_credited_db,
69: p_freight_credited_db
70: FROM ar_receivable_applications ra
71: WHERE customer_trx_id = p_ct_id
72: AND applied_customer_trx_id = p_prev_ct_id;
73:
74: END IF;