APPS.ARP_BR_HOUSEKEEPER_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 9: customer_trx_id ar_payment_schedules.customer_trx_id%TYPE,

5: /*----------------------------------------------------+
6: | Package global record (private) for BR information |
7: +----------------------------------------------------*/
8: TYPE BR_rec_type IS RECORD (
9: customer_trx_id ar_payment_schedules.customer_trx_id%TYPE,
10: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
11: maturity_date ar_payment_schedules.due_date%TYPE,
12: reserved_type ar_payment_schedules.reserved_type%TYPE,
13: reserved_value ar_payment_schedules.reserved_value%TYPE,

Line 10: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,

6: | Package global record (private) for BR information |
7: +----------------------------------------------------*/
8: TYPE BR_rec_type IS RECORD (
9: customer_trx_id ar_payment_schedules.customer_trx_id%TYPE,
10: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
11: maturity_date ar_payment_schedules.due_date%TYPE,
12: reserved_type ar_payment_schedules.reserved_type%TYPE,
13: reserved_value ar_payment_schedules.reserved_value%TYPE,
14: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,

Line 11: maturity_date ar_payment_schedules.due_date%TYPE,

7: +----------------------------------------------------*/
8: TYPE BR_rec_type IS RECORD (
9: customer_trx_id ar_payment_schedules.customer_trx_id%TYPE,
10: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
11: maturity_date ar_payment_schedules.due_date%TYPE,
12: reserved_type ar_payment_schedules.reserved_type%TYPE,
13: reserved_value ar_payment_schedules.reserved_value%TYPE,
14: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
15: tax_remaining ar_payment_schedules.tax_remaining%TYPE,

Line 12: reserved_type ar_payment_schedules.reserved_type%TYPE,

8: TYPE BR_rec_type IS RECORD (
9: customer_trx_id ar_payment_schedules.customer_trx_id%TYPE,
10: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
11: maturity_date ar_payment_schedules.due_date%TYPE,
12: reserved_type ar_payment_schedules.reserved_type%TYPE,
13: reserved_value ar_payment_schedules.reserved_value%TYPE,
14: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
15: tax_remaining ar_payment_schedules.tax_remaining%TYPE,
16: gl_date ar_transaction_history.gl_date%TYPE,

Line 13: reserved_value ar_payment_schedules.reserved_value%TYPE,

9: customer_trx_id ar_payment_schedules.customer_trx_id%TYPE,
10: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
11: maturity_date ar_payment_schedules.due_date%TYPE,
12: reserved_type ar_payment_schedules.reserved_type%TYPE,
13: reserved_value ar_payment_schedules.reserved_value%TYPE,
14: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
15: tax_remaining ar_payment_schedules.tax_remaining%TYPE,
16: gl_date ar_transaction_history.gl_date%TYPE,
17: transaction_history_id ar_transaction_history.transaction_history_id%TYPE,

Line 14: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,

10: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
11: maturity_date ar_payment_schedules.due_date%TYPE,
12: reserved_type ar_payment_schedules.reserved_type%TYPE,
13: reserved_value ar_payment_schedules.reserved_value%TYPE,
14: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
15: tax_remaining ar_payment_schedules.tax_remaining%TYPE,
16: gl_date ar_transaction_history.gl_date%TYPE,
17: transaction_history_id ar_transaction_history.transaction_history_id%TYPE,
18: prv_trx_history_id ar_transaction_history.prv_trx_history_id%TYPE,

Line 15: tax_remaining ar_payment_schedules.tax_remaining%TYPE,

11: maturity_date ar_payment_schedules.due_date%TYPE,
12: reserved_type ar_payment_schedules.reserved_type%TYPE,
13: reserved_value ar_payment_schedules.reserved_value%TYPE,
14: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
15: tax_remaining ar_payment_schedules.tax_remaining%TYPE,
16: gl_date ar_transaction_history.gl_date%TYPE,
17: transaction_history_id ar_transaction_history.transaction_history_id%TYPE,
18: prv_trx_history_id ar_transaction_history.prv_trx_history_id%TYPE,
19: status ar_transaction_history.status%TYPE,

Line 139: from ar_transaction_history trh, ar_payment_schedules ps

135: trh.prv_trx_history_id,
136: trh.status,
137: trh.event,
138: ps.org_id
139: from ar_transaction_history trh, ar_payment_schedules ps
140: where
141: /*-----------------------------------------------------+
142: | Restrict the transaction type if given as parameter |
143: +-----------------------------------------------------*/

Line 861: FROM ra_customer_trx ct, ar_payment_schedules ps

857: ct.customer_bank_account_id,
858: ct.trx_number,
859: ct.term_due_date maturity_date,
860: ct.org_id
861: FROM ra_customer_trx ct, ar_payment_schedules ps
862: WHERE ct.customer_trx_id = pg_BR_rec.customer_trx_id
863: AND ps.customer_trx_id = ct.customer_trx_id;
864:
865: l_return_status VARCHAR2(1);