APPS.IGS_AZ_GEN_001 dependencies on IGS_PE_PERSID_GROUP_ALL

Line 18: smanglm 05-Aug-2003 Bug 3084766: Make use of Dynamic Person ID Group if the igs_pe_persid_group_all.FILE_NAME

14: Who When What
15: -----------------------------------------------------------
16: Girish Jha 12-May-2003 New Package created.
17: anilk 03-Jul-2003 Fixed Bug# 3032626, STUDENT/ADVISOR STILL ACTIVE ON THE END DATE
18: smanglm 05-Aug-2003 Bug 3084766: Make use of Dynamic Person ID Group if the igs_pe_persid_group_all.FILE_NAME
19: is not null else make use of static query. Changes made in the
20: following cursors of maintain_groups:
21: cur_std_to_add
22: cur_adv_to_add

Line 60: -- of igs_pe_persid_group_all.file_name for the given group_id

56: --
57: l_status VARCHAR2 (2000);
58: --
59: -- Cursor to check whether dynamic person_id_group has to be used or not based on the value
60: -- of igs_pe_persid_group_all.file_name for the given group_id
61: --
62: CURSOR c_is_filename_null (cp_group_id igs_pe_persid_group_all.GROUP_ID%TYPE) IS
63: SELECT 'Y'
64: FROM igs_pe_persid_group_all

Line 62: CURSOR c_is_filename_null (cp_group_id igs_pe_persid_group_all.GROUP_ID%TYPE) IS

58: --
59: -- Cursor to check whether dynamic person_id_group has to be used or not based on the value
60: -- of igs_pe_persid_group_all.file_name for the given group_id
61: --
62: CURSOR c_is_filename_null (cp_group_id igs_pe_persid_group_all.GROUP_ID%TYPE) IS
63: SELECT 'Y'
64: FROM igs_pe_persid_group_all
65: WHERE GROUP_ID = cp_group_id AND file_name IS NULL;
66: --

Line 64: FROM igs_pe_persid_group_all

60: -- of igs_pe_persid_group_all.file_name for the given group_id
61: --
62: CURSOR c_is_filename_null (cp_group_id igs_pe_persid_group_all.GROUP_ID%TYPE) IS
63: SELECT 'Y'
64: FROM igs_pe_persid_group_all
65: WHERE GROUP_ID = cp_group_id AND file_name IS NULL;
66: --
67: l_adv_is_filename_null VARCHAR2 (1) := 'N';
68: l_std_is_filename_null VARCHAR2 (1) := 'N';