APPS.IGS_PE_PERSON_SS_PKG dependencies on IGS_PE_DATA_GROUPS

Line 91: FROM igs_pe_data_groups

87: WHERE privacy_level_id = cp_privacy_level_id;
88:
89: CURSOR data_group_cur (cp_data_group_id NUMBER) IS
90: SELECT data_group, lvl
91: FROM igs_pe_data_groups
92: WHERE data_group_id = p_data_group_id;
93:
94: l_data_group IGS_PE_DATA_GROUPS.data_group%TYPE;
95: l_lvl IGS_PE_DATA_GROUPS.lvl%TYPE;

Line 94: l_data_group IGS_PE_DATA_GROUPS.data_group%TYPE;

90: SELECT data_group, lvl
91: FROM igs_pe_data_groups
92: WHERE data_group_id = p_data_group_id;
93:
94: l_data_group IGS_PE_DATA_GROUPS.data_group%TYPE;
95: l_lvl IGS_PE_DATA_GROUPS.lvl%TYPE;
96: l_ref_notes_id igs_pe_priv_level.ref_notes_id%TYPE;
97: BEGIN
98: -- Standard Start of API savepoint

Line 95: l_lvl IGS_PE_DATA_GROUPS.lvl%TYPE;

91: FROM igs_pe_data_groups
92: WHERE data_group_id = p_data_group_id;
93:
94: l_data_group IGS_PE_DATA_GROUPS.data_group%TYPE;
95: l_lvl IGS_PE_DATA_GROUPS.lvl%TYPE;
96: l_ref_notes_id igs_pe_priv_level.ref_notes_id%TYPE;
97: BEGIN
98: -- Standard Start of API savepoint
99: SAVEPOINT Update_Privacy;