APPS.IGS_PE_USERID_PKG dependencies on IGS_PE_PERSID_GROUP_ALL

Line 888: FROM igs_pe_persid_group_all pe

884: l_group_cd VARCHAR2(10);
885:
886: CURSOR c_person_id_group (cp_group_id NUMBER) IS
887: SELECT pe.group_cd
888: FROM igs_pe_persid_group_all pe
889: WHERE pe.group_id = cp_group_id
890: AND pe.closed_ind = 'N'
891: AND pe.create_dt <= SYSDATE;
892:

Line 1033: CURSOR cur_person_grp_desc(cp_group_id igs_pe_persid_group_all.group_id%TYPE) IS

1029: l_init_msg_list VARCHAR2(100);
1030: l_valid_lvl NUMBER;
1031: -- changed the cursor to pick up only active members of the group
1032:
1033: CURSOR cur_person_grp_desc(cp_group_id igs_pe_persid_group_all.group_id%TYPE) IS
1034: SELECT description
1035: FROM igs_pe_persid_group_all
1036: WHERE group_id = cp_group_id;
1037:

Line 1035: FROM igs_pe_persid_group_all

1031: -- changed the cursor to pick up only active members of the group
1032:
1033: CURSOR cur_person_grp_desc(cp_group_id igs_pe_persid_group_all.group_id%TYPE) IS
1034: SELECT description
1035: FROM igs_pe_persid_group_all
1036: WHERE group_id = cp_group_id;
1037:
1038: l_select VARCHAR2(32767);
1039: l_str VARCHAR2(32767);