APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_FI_INV_INT

Line 651: -- tp access data from igs_fi_inv_int instead of IGS_FI_FEE_AS for bug#4177199

647: -- Purpose : This procedure checks for the debt
648: --Change History:
649: --Who When What
650: --bdeviset 08-APR-2005 Changed cursors c_get_debt_for_src_prgm_att and c_get_debt_for_src_prgm_att
651: -- tp access data from igs_fi_inv_int instead of IGS_FI_FEE_AS for bug#4177199
652: -------------------------------------------------------------------------------------------
653: l_debt_exists IGS_FI_FEE_AS.person_id%TYPE;
654: CURSOR c_get_debt_for_src_prgm_att IS
655: SELECT person_id

Line 656: FROM igs_fi_inv_int

652: -------------------------------------------------------------------------------------------
653: l_debt_exists IGS_FI_FEE_AS.person_id%TYPE;
654: CURSOR c_get_debt_for_src_prgm_att IS
655: SELECT person_id
656: FROM igs_fi_inv_int
657: WHERE person_id = p_person_id
658: AND course_cd = p_source_program_cd
659: AND transaction_type IN ('ASSESSMENT', 'RETENTION', 'SPECIAL')
660: AND invoice_amount_due > 0;

Line 664: FROM igs_fi_inv_int

660: AND invoice_amount_due > 0;
661:
662: CURSOR c_getdebt_for_all_prgms IS
663: SELECT person_id
664: FROM igs_fi_inv_int
665: WHERE person_id = p_person_id
666: AND course_cd IS NULL
667: AND invoice_amount_due > 0;
668: