eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROGRAM_BR_REMIT dependencies on AR_PAYMENT_SCHEDULES

Line 27: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

23: PROCEDURE create_remit_pvt(
24: p_batch_id IN AR_BATCHES.batch_id%TYPE,
25: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
26: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
27: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
28: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
29: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
30: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
31: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 28: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

24: p_batch_id IN AR_BATCHES.batch_id%TYPE,
25: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
26: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
27: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
28: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
29: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
30: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
31: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
32: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 29: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

25: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
26: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
27: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
28: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
29: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
30: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
31: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
32: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
33: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 30: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

26: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
27: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
28: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
29: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
30: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
31: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
32: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
33: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
34: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 31: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

27: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
28: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
29: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
30: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
31: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
32: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
33: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
34: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
35: p_unsigned_flag IN varchar2,

Line 32: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

28: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
29: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
30: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
31: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
32: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
33: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
34: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
35: p_unsigned_flag IN varchar2,
36: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 33: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

29: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
30: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
31: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
32: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
33: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
34: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
35: p_unsigned_flag IN varchar2,
36: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
37: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

Line 34: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

30: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
31: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
32: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
33: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
34: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
35: p_unsigned_flag IN varchar2,
36: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
37: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
38: p_include_unpaid_flag IN varchar2,

Line 39: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

35: p_unsigned_flag IN varchar2,
36: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
37: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
38: p_include_unpaid_flag IN varchar2,
39: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
40: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
41: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
42: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
43: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

Line 150: l_maturity_date_low AR_PAYMENT_SCHEDULES.due_date%TYPE;

146:
147: l_batch_id AR_BATCHES.batch_id%TYPE;
148: l_remit_total_low AR_BATCHES.control_amount%TYPE;
149: l_remit_total_high AR_BATCHES.control_amount%TYPE;
150: l_maturity_date_low AR_PAYMENT_SCHEDULES.due_date%TYPE;
151: l_maturity_date_high AR_PAYMENT_SCHEDULES.due_date%TYPE;
152: l_br_amount_low AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
153: l_br_amount_high AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
154: l_transaction_type1_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;

Line 151: l_maturity_date_high AR_PAYMENT_SCHEDULES.due_date%TYPE;

147: l_batch_id AR_BATCHES.batch_id%TYPE;
148: l_remit_total_low AR_BATCHES.control_amount%TYPE;
149: l_remit_total_high AR_BATCHES.control_amount%TYPE;
150: l_maturity_date_low AR_PAYMENT_SCHEDULES.due_date%TYPE;
151: l_maturity_date_high AR_PAYMENT_SCHEDULES.due_date%TYPE;
152: l_br_amount_low AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
153: l_br_amount_high AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
154: l_transaction_type1_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
155: l_transaction_type2_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;

Line 152: l_br_amount_low AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

148: l_remit_total_low AR_BATCHES.control_amount%TYPE;
149: l_remit_total_high AR_BATCHES.control_amount%TYPE;
150: l_maturity_date_low AR_PAYMENT_SCHEDULES.due_date%TYPE;
151: l_maturity_date_high AR_PAYMENT_SCHEDULES.due_date%TYPE;
152: l_br_amount_low AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
153: l_br_amount_high AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
154: l_transaction_type1_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
155: l_transaction_type2_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
156: l_drawee_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;

Line 153: l_br_amount_high AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

149: l_remit_total_high AR_BATCHES.control_amount%TYPE;
150: l_maturity_date_low AR_PAYMENT_SCHEDULES.due_date%TYPE;
151: l_maturity_date_high AR_PAYMENT_SCHEDULES.due_date%TYPE;
152: l_br_amount_low AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
153: l_br_amount_high AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
154: l_transaction_type1_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
155: l_transaction_type2_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
156: l_drawee_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
157: l_drawee_bank_branch_id CE_BANK_BRANCHES_V.branch_party_id%TYPE;

Line 154: l_transaction_type1_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;

150: l_maturity_date_low AR_PAYMENT_SCHEDULES.due_date%TYPE;
151: l_maturity_date_high AR_PAYMENT_SCHEDULES.due_date%TYPE;
152: l_br_amount_low AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
153: l_br_amount_high AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
154: l_transaction_type1_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
155: l_transaction_type2_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
156: l_drawee_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
157: l_drawee_bank_branch_id CE_BANK_BRANCHES_V.branch_party_id%TYPE;
158:

Line 155: l_transaction_type2_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;

151: l_maturity_date_high AR_PAYMENT_SCHEDULES.due_date%TYPE;
152: l_br_amount_low AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
153: l_br_amount_high AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
154: l_transaction_type1_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
155: l_transaction_type2_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
156: l_drawee_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
157: l_drawee_bank_branch_id CE_BANK_BRANCHES_V.branch_party_id%TYPE;
158:
159: BEGIN

Line 156: l_drawee_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;

152: l_br_amount_low AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
153: l_br_amount_high AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
154: l_transaction_type1_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
155: l_transaction_type2_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
156: l_drawee_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
157: l_drawee_bank_branch_id CE_BANK_BRANCHES_V.branch_party_id%TYPE;
158:
159: BEGIN
160:

Line 308: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

304: PROCEDURE create_remit_pvt(
305: p_batch_id IN AR_BATCHES.batch_id%TYPE,
306: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
307: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
308: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
309: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
310: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
311: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
312: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 309: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

305: p_batch_id IN AR_BATCHES.batch_id%TYPE,
306: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
307: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
308: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
309: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
310: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
311: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
312: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
313: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 310: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

306: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
307: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
308: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
309: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
310: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
311: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
312: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
313: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
314: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 311: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

307: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
308: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
309: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
310: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
311: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
312: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
313: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
314: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
315: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 312: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

308: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
309: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
310: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
311: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
312: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
313: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
314: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
315: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
316: p_unsigned_flag IN varchar2,

Line 313: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

309: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
310: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
311: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
312: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
313: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
314: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
315: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
316: p_unsigned_flag IN varchar2,
317: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 314: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

310: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
311: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
312: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
313: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
314: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
315: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
316: p_unsigned_flag IN varchar2,
317: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
318: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

Line 315: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

311: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
312: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
313: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
314: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
315: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
316: p_unsigned_flag IN varchar2,
317: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
318: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
319: p_include_unpaid_flag IN varchar2,

Line 320: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

316: p_unsigned_flag IN varchar2,
317: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
318: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
319: p_include_unpaid_flag IN varchar2,
320: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
321: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
322: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
323: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
324: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

Line 409: -- The selected BR are assigned to the remittance by updating the reserved columns in the table AR_PAYMENT_SCHEDULES

405: p_drawee_sort_criteria,
406: p_drawee_order,
407: l_select_detail);
408:
409: -- The selected BR are assigned to the remittance by updating the reserved columns in the table AR_PAYMENT_SCHEDULES
410: -- until the parameter remittance maximum amount is reached (If it is filled of course).
411: ARP_PROCESS_BR_REMIT.assign_br_to_remit(
412: l_select_detail,
413: l_batch_rec.batch_id,

Line 571: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

567: PROCEDURE approve_remit_pvt(
568: p_batch_id IN AR_BATCHES.batch_id%TYPE) IS
569:
570: l_batch_rec AR_BATCHES%ROWTYPE;
571: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
572:
573: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
574:
575: CURSOR cur_br IS

Line 577: FROM AR_PAYMENT_SCHEDULES

573: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
574:
575: CURSOR cur_br IS
576: SELECT payment_schedule_id
577: FROM AR_PAYMENT_SCHEDULES
578: WHERE reserved_type = 'REMITTANCE'
579: AND reserved_value = p_batch_id;
580:
581: BEGIN