DBA Data[Home] [Help]

APPS.IGF_SP_AWARD dependencies on IGS_PE_ALL_PERSID_GROUP_V

Line 2253: CURSOR c_pers_id_grp(cp_n_pers_grp_id igs_pe_all_persid_group_v.group_id%TYPE)

2249: -- cursor variable for c_igf_aw_fund_mast
2250: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
2251:
2252: -- Cursor for validating the Person Id Group
2253: CURSOR c_pers_id_grp(cp_n_pers_grp_id igs_pe_all_persid_group_v.group_id%TYPE)
2254: IS
2255: SELECT group_cd, closed_ind
2256: FROM igs_pe_all_persid_group_v
2257: WHERE group_id = cp_n_pers_grp_id;

Line 2256: FROM igs_pe_all_persid_group_v

2252: -- Cursor for validating the Person Id Group
2253: CURSOR c_pers_id_grp(cp_n_pers_grp_id igs_pe_all_persid_group_v.group_id%TYPE)
2254: IS
2255: SELECT group_cd, closed_ind
2256: FROM igs_pe_all_persid_group_v
2257: WHERE group_id = cp_n_pers_grp_id;
2258: l_c_pers_id_grp c_pers_id_grp%ROWTYPE;
2259:
2260: CURSOR c_validate_fund_id(cp_n_fund_id igf_aw_fund_mast.fund_id%TYPE)