DBA Data[Home] [Help]

APPS.AR_BILLS_CREATION_LIB_PVT dependencies on RA_CUSTOMER_TRX_LINES

Line 777: PROCEDURE Default_Create_BR_Assignment (p_trl_rec IN OUT NOCOPY ra_customer_trx_lines%ROWTYPE,

773: | |
774: +==============================================================================*/
775:
776:
777: PROCEDURE Default_Create_BR_Assignment (p_trl_rec IN OUT NOCOPY ra_customer_trx_lines%ROWTYPE,
778: p_ps_rec IN ar_payment_schedules%ROWTYPE )
779: IS
780:
781: l_amount_due_remaining NUMBER;

Line 797: FROM RA_CUSTOMER_TRX_LINES

793: +-----------------------------------------------*/
794:
795: SELECT count(*)
796: INTO l_count
797: FROM RA_CUSTOMER_TRX_LINES
798: WHERE br_ref_payment_schedule_id = p_ps_rec.payment_schedule_id
799: AND customer_trx_id = p_trl_rec.customer_trx_id;
800:
801: IF (l_count > 0)

Line 862: FROM ra_customer_trx_lines

858: IS
859:
860: CURSOR assignment_cur IS
861: SELECT customer_trx_line_id
862: FROM ra_customer_trx_lines
863: WHERE customer_trx_id = p_customer_trx_id;
864:
865: assignment_rec assignment_cur%ROWTYPE;
866: