DBA Data[Home] [Help]

APPS.IEX_PAYMENTS_PUB dependencies on IEX_DELINQUENCIES

Line 724: -- get del_id from iex_delinquencies table

720: -- generate new receipt number
721: CURSOR rc_genid_crs IS
722: select IEX_RECEIPT_NUMBER_S.NEXTVAL from dual;
723:
724: -- get del_id from iex_delinquencies table
725: CURSOR get_delid_crs(p_payment_schedule_id number) IS
726: select delinquency_id
727: from iex_delinquencies
728: where payment_schedule_id = p_payment_schedule_id;

Line 727: from iex_delinquencies

723:
724: -- get del_id from iex_delinquencies table
725: CURSOR get_delid_crs(p_payment_schedule_id number) IS
726: select delinquency_id
727: from iex_delinquencies
728: where payment_schedule_id = p_payment_schedule_id;
729:
730: BEGIN
731: