APPS.IGS_PE_DYNAMIC_PERSID_GROUP dependencies on IGS_PE_PERSID_GROUP_ALL

Line 23: p_GroupID IN igs_pe_persid_group_all.group_id%TYPE,

19: | id group |
20: +==========================================================================*/
21:
22: FUNCTION IGS_GET_DYNAMIC_SQL(
23: p_GroupID IN igs_pe_persid_group_all.group_id%TYPE,
24: p_Status OUT NOCOPY VARCHAR2) RETURN VARCHAR2
25: IS
26:
27: --local variables

Line 45: FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S

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
46: WHERE G.group_id = p_GroupID
47: AND G.file_name = S.file_name
48: ORDER BY S.seg_sequence_num;
49:

Line 134: p_GroupID IN igs_pe_persid_group_all.group_id%TYPE,

130: END IGS_GET_DYNAMIC_SQL;
131:
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:

Line 158: FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S

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
159: WHERE G.group_id = p_GroupID
160: AND G.file_name = S.file_name
161: ORDER BY S.seg_sequence_num;
162:

Line 265: FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S

261: c_person_id_grp_rec c_person_id_grp_recTyp ;
262:
263: CURSOR c_Rec IS
264: SELECT S.sql_segment
265: FROM IGS_PE_PERSID_GROUP_ALL G, IGS_PE_DYN_SQLSEGS S
266: WHERE G.group_id = p_GroupID
267: AND G.file_name = S.file_name
268: ORDER BY S.seg_sequence_num;
269: