DBA Data[Home] [Help]

APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_FI_FEE_AS

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 653: l_debt_exists IGS_FI_FEE_AS.person_id%TYPE;

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
656: FROM igs_fi_inv_int
657: WHERE person_id = p_person_id