DBA Data[Home] [Help]

APPS.IGS_FI_PRC_APINT dependencies on IGS_PE_ALL_PERSID_GROUP_V

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

333:
334: l_c_party c_party%ROWTYPE;
335:
336: -- Cursor for validating the Person Group
337: CURSOR c_pers_id_grp(cp_n_pers_grp_id igs_pe_all_persid_group_v.group_id%TYPE) IS
338: SELECT group_cd, closed_ind
339: FROM igs_pe_all_persid_group_v
340: WHERE group_id = cp_n_pers_grp_id;
341:

Line 339: FROM igs_pe_all_persid_group_v

335:
336: -- Cursor for validating the Person Group
337: CURSOR c_pers_id_grp(cp_n_pers_grp_id igs_pe_all_persid_group_v.group_id%TYPE) IS
338: SELECT group_cd, closed_ind
339: FROM igs_pe_all_persid_group_v
340: WHERE group_id = cp_n_pers_grp_id;
341:
342: l_c_pers_id_grp c_pers_id_grp%ROWTYPE;
343: