APPS.IGF_AP_VER_GRPS_PRC_PKG dependencies on IGS_PE_PERSID_GROUP_ALL

Line 86: CURSOR c_person_group( cp_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE ) IS

82: WHERE pe.person_id = fa.person_id
83: AND fa.base_id = cp_base_id;
84:
85: -- Get the details of group
86: CURSOR c_person_group( cp_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE ) IS
87: SELECT description
88: FROM igs_pe_persid_group
89: WHERE group_id = cp_person_id_grp;
90:

Line 113: l_group_desc igs_pe_persid_group_all.description%TYPE;

109: lv_isir_field_pmpt igf_lookups_view.meaning%TYPE ;
110: l_para_pass igf_lookups_view.meaning%TYPE ;
111:
112: l_person_number igs_pe_person_base_v.person_number%TYPE;
113: l_group_desc igs_pe_persid_group_all.description%TYPE;
114: l_item_description igf_ap_td_item_mst_all.description%TYPE;
115:
116:
117: BEGIN