APPS.AR_BILLS_MAINTAIN_LIB_PVT dependencies on RA_CUSTOMER_TRX_LINES

Line 608: FROM ra_customer_trx_lines

604:
605: CURSOR assignment_cur IS
606: SELECT br_ref_customer_trx_id, br_ref_payment_schedule_id, extended_amount,
607: customer_trx_line_id, extended_acctd_amount
608: FROM ra_customer_trx_lines
609: WHERE customer_trx_id = p_trh_rec.customer_trx_id;
610:
611: assignment_rec assignment_cur%ROWTYPE ;
612:

Line 656: UPDATE ra_customer_trx_lines

652: +-----------------------------------------------*/
653:
654: arp_ctl_pkg.lock_p (assignment_rec.customer_trx_line_id);
655:
656: UPDATE ra_customer_trx_lines
657: SET br_adjustment_id = l_new_adjust_id
658: WHERE customer_trx_line_id = assignment_rec.customer_trx_line_id;
659:
660:

Line 740: FROM ra_customer_trx_lines

736:
737:
738: CURSOR assignment_cur IS
739: SELECT br_ref_payment_schedule_id
740: FROM ra_customer_trx_lines
741: WHERE customer_trx_id = p_customer_trx_id;
742:
743: assignment_rec assignment_cur%ROWTYPE ;
744:

Line 1310: FROM ra_customer_trx_lines

1306: IS
1307:
1308: CURSOR assignment_cur IS
1309: SELECT br_adjustment_id, br_ref_payment_schedule_id, customer_trx_line_id, br_ref_customer_trx_id
1310: FROM ra_customer_trx_lines
1311: WHERE customer_trx_id = p_trh_rec.customer_trx_id;
1312:
1313: assignment_rec assignment_cur%ROWTYPE ;
1314:

Line 1349: UPDATE ra_customer_trx_lines

1345:
1346:
1347: arp_ctl_pkg.lock_p (assignment_rec.customer_trx_line_id);
1348:
1349: UPDATE ra_customer_trx_lines
1350: SET br_adjustment_id = NULL
1351: WHERE customer_trx_line_id = assignment_rec.customer_trx_line_id;
1352:
1353: