DBA Data[Home] [Help]

APPS.ARP_INST_UTIL_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 16: p_line_credited OUT NOCOPY ar_receivable_applications.line_applied%type,

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,

Line 17: p_line_credited_db OUT NOCOPY ar_receivable_applications.line_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,

Line 18: p_charges_credited OUT NOCOPY ar_receivable_applications.line_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,

Line 19: p_charges_credited_db OUT NOCOPY ar_receivable_applications.line_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)

Line 20: p_tax_credited OUT NOCOPY ar_receivable_applications.tax_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

Line 21: p_tax_credited_db OUT NOCOPY ar_receivable_applications.tax_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
25: BEGIN

Line 22: p_freight_credited OUT NOCOPY ar_receivable_applications.freight_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
26: arp_util.debug('arp_inst_util_pkg.select_inst_summary()+');

Line 23: p_freight_credited_db OUT NOCOPY ar_receivable_applications.freight_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()+');
27:

Line 70: FROM ar_receivable_applications ra

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;