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 1348: FROM ra_customer_trx_lines

1344: IS
1345:
1346: CURSOR assignment_cur IS
1347: SELECT br_adjustment_id, br_ref_payment_schedule_id, customer_trx_line_id, br_ref_customer_trx_id
1348: FROM ra_customer_trx_lines
1349: WHERE customer_trx_id = p_trh_rec.customer_trx_id;
1350:
1351: assignment_rec assignment_cur%ROWTYPE ;
1352:

Line 1387: UPDATE ra_customer_trx_lines

1383:
1384:
1385: arp_ctl_pkg.lock_p (assignment_rec.customer_trx_line_id);
1386:
1387: UPDATE ra_customer_trx_lines
1388: SET br_adjustment_id = NULL
1389: WHERE customer_trx_line_id = assignment_rec.customer_trx_line_id;
1390:
1391: