DBA Data[Home] [Help]

APPS.IGF_GR_PELL_CALC dependencies on IGF_AP_ISIR_MATCHED

Line 842: FROM igf_ap_isir_matched isir

838: CURSOR c_isir ( l_base_id NUMBER )
839: IS
840: SELECT
841: summ_enrl_status
842: FROM igf_ap_isir_matched isir
843: WHERE
844: isir.base_id = l_base_id AND
845: isir.active_isir = 'Y' ;
846:

Line 1956: FROM igf_ap_isir_matched ism

1952:
1953: CURSOR c_pell_elig ( l_base_id NUMBER ) IS
1954: SELECT NVL(pell_grant_elig_flag, 'N') pell_grant_elig_flag,
1955: transaction_num
1956: FROM igf_ap_isir_matched ism
1957: WHERE ism.base_id = l_base_id
1958: AND ism.active_isir = 'Y';
1959:
1960: l_pell_elig c_pell_elig%ROWTYPE;

Line 3072: FROM igf_ap_isir_matched ism

3068: -- Payment ISIR.
3069:
3070: CURSOR c_pell_elig ( l_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS
3071: SELECT NVL(ism.pell_grant_elig_flag, 'N') pell_grant_elig_flag
3072: FROM igf_ap_isir_matched ism
3073: WHERE ism.base_id = l_base_id
3074: AND ism.active_isir = 'Y' ;
3075:
3076: l_pell_elig c_pell_elig%ROWTYPE;