APPS.IGS_PE_DYNAMIC_PERSID_GROUP dependencies on IGS_PE_DYN_SQLSEGS_S

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 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:

Line 414: IGS_PE_DYN_SQLSEGS_S.nextval,

410: LAST_UPDATED_BY,
411: LAST_UPDATE_DATE
412: )
413: VALUES (
414: IGS_PE_DYN_SQLSEGS_S.nextval,
415: UPPER(p_WorkBookName)||':'||UPPER(p_WorkSheetName),
416: p_Sequence,
417: l_sqltxt,
418: l_creator_id,

Line 463: FROM IGS_PE_DYN_SQLSEGS S

459: x_Data VARCHAR2(2000);
460:
461: CURSOR c_Rec (cp_FileName IGS_PE_DYN_SQLSEGS.file_name%TYPE) IS
462: SELECT S.sql_segment
463: FROM IGS_PE_DYN_SQLSEGS S
464: WHERE S.file_name = cp_FileName
465: ORDER BY S.seg_sequence_num;
466:
467: BEGIN