APPS.IGS_PE_DYNAMIC_PERSID_GROUP dependencies on IGS_PE_PERSID_GROUP_V

Line 39: FROM IGS_PE_PERSID_GROUP_V

35: x_Data VARCHAR2(2000);
36:
37: CURSOR c_group_type IS
38: SELECT group_type
39: FROM IGS_PE_PERSID_GROUP_V
40: WHERE group_id = p_GroupID;
41: lv_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;
42:
43: CURSOR c_Rec IS

Line 41: lv_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;

37: CURSOR c_group_type IS
38: SELECT group_type
39: FROM IGS_PE_PERSID_GROUP_V
40: WHERE group_id = p_GroupID;
41: lv_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;
42:
43: CURSOR c_Rec IS
44: SELECT S.sql_segment
45: FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S

Line 136: p_group_type OUT NOCOPY IGS_PE_PERSID_GROUP_V.group_type%TYPE) RETURN VARCHAR2

132:
133: FUNCTION GET_DYNAMIC_SQL(
134: p_GroupID IN igs_pe_persid_group_all.group_id%TYPE,
135: p_Status OUT NOCOPY VARCHAR2,
136: p_group_type OUT NOCOPY IGS_PE_PERSID_GROUP_V.group_type%TYPE) RETURN VARCHAR2
137: IS
138:
139: --local variables
140:

Line 152: FROM IGS_PE_PERSID_GROUP_V

148:
149:
150: CURSOR c_group_type IS
151: SELECT group_type
152: FROM IGS_PE_PERSID_GROUP_V
153: WHERE group_id = p_GroupID;
154: lv_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;
155:
156: CURSOR c_Rec IS

Line 154: lv_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;

150: CURSOR c_group_type IS
151: SELECT group_type
152: FROM IGS_PE_PERSID_GROUP_V
153: WHERE group_id = p_GroupID;
154: lv_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;
155:
156: CURSOR c_Rec IS
157: SELECT S.sql_segment
158: FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S