eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_WRKFLOW_PKG dependencies on IGS_PE_PRSID_GRP_MEM

Line 8: p_person_id_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,

4: PROCEDURE Extract_Applications
5: ( errbuf OUT NOCOPY VARCHAR2,
6: retcode OUT NOCOPY NUMBER ,
7: p_person_id IN hz_parties.party_id%TYPE,
8: p_person_id_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
9: p_calendar_details IN VARCHAR2,
10: p_apc IN VARCHAR2,
11: p_appl_type IN VARCHAR2,
12: p_prog_code IN VARCHAR2,

Line 46: FROM igs_pe_prsid_grp_mem pgm

42: Where
43: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
44: AND (p_person_id_group IS NOT NULL AND
45: aa.person_id IN (SELECT person_id
46: FROM igs_pe_prsid_grp_mem pgm
47: WHERE pgm.group_id = nvl(p_person_id_group, pgm.group_id)
48: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
49: OR
50: (p_person_id_group is null))

Line 65: FROM igs_pe_prsid_grp_mem pgm

61: Where
62: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL)) AND
63: (p_person_id_group IS NOT NULL AND
64: aa.person_id IN (SELECT person_id
65: FROM igs_pe_prsid_grp_mem pgm
66: WHERE pgm.group_id = nvl(p_person_id_group,pgm.group_id)
67: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
68: OR
69: (p_person_id_group is null)) AND

Line 84: FROM igs_pe_prsid_grp_mem pgm

80: From IGS_SS_ADM_APPL_STG aa
81: Where ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
82: AND (p_person_id_group IS NOT NULL AND
83: aa.person_id IN (SELECT person_id
84: FROM igs_pe_prsid_grp_mem pgm
85: WHERE pgm.group_id = nvl(p_person_id_group,pgm.group_id)
86: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
87: OR
88: (p_person_id_group is null))

Line 106: FROM igs_pe_prsid_grp_mem pgm

102: aap.SS_ADM_APPL_ID = aa.SS_ADM_APPL_ID(+)
103: And ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
104: AND (p_person_id_group IS NOT NULL AND
105: aa.person_id IN (SELECT person_id
106: FROM igs_pe_prsid_grp_mem pgm
107: WHERE pgm.group_id = nvl(p_person_id_group,pgm.group_id)
108: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
109: OR
110: (p_person_id_group is null))

Line 129: FROM igs_pe_prsid_grp_mem pgm

125: Where
126: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
127: AND (p_person_id_group IS NOT NULL AND
128: aa.person_id IN (SELECT person_id
129: FROM igs_pe_prsid_grp_mem pgm
130: WHERE pgm.group_id = nvl(p_person_id_group,pgm.group_id)
131: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
132: OR
133: (p_person_id_group is null))

Line 149: FROM igs_pe_prsid_grp_mem pgm

145: Where aap.SS_ADM_APPL_ID = aa.SS_ADM_APPL_ID(+)
146: And ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
147: AND (p_person_id_group IS NOT NULL AND
148: aa.person_id IN (SELECT person_id
149: FROM igs_pe_prsid_grp_mem pgm
150: WHERE pgm.group_id = nvl(p_person_id_group,pgm.group_id)
151: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
152: OR
153: (p_person_id_group is null))

Line 174: FROM igs_pe_prsid_grp_mem pgm

170: Where
171: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
172: AND (p_person_id_group IS NOT NULL
173: AND aa.person_id IN (SELECT person_id
174: FROM igs_pe_prsid_grp_mem pgm
175: WHERE pgm.group_id = p_person_id_group
176: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
177: OR
178: (p_person_id_group is null))

Line 192: FROM igs_pe_prsid_grp_mem pgm

188: Where
189: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
190: AND (p_person_id_group IS NOT NULL
191: AND aa.person_id IN (SELECT person_id
192: FROM igs_pe_prsid_grp_mem pgm
193: WHERE pgm.group_id = p_person_id_group
194: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
195: OR
196: (p_person_id_group is null))

Line 242: FROM igs_pe_prsid_grp_mem pgm

238: Where
239: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
240: AND (p_person_id_group IS NOT NULL
241: AND aa.person_id IN (SELECT person_id
242: FROM igs_pe_prsid_grp_mem pgm
243: WHERE pgm.group_id = p_person_id_group
244: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
245: OR
246: (p_person_id_group is null))

Line 261: FROM igs_pe_prsid_grp_mem pgm

257: From IGS_SS_ADM_APPL_STG aa
258: Where ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
259: AND (p_person_id_group IS NOT NULL AND
260: aa.person_id IN (SELECT person_id
261: FROM igs_pe_prsid_grp_mem pgm
262: WHERE pgm.group_id = p_person_id_group
263: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
264: OR
265: (p_person_id_group is null))

Line 280: FROM igs_pe_prsid_grp_mem pgm

276: Where
277: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
278: AND (p_person_id_group IS NOT NULL AND
279: aa.person_id IN (SELECT person_id
280: FROM igs_pe_prsid_grp_mem pgm
281: WHERE pgm.group_id = p_person_id_group
282: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
283: OR
284: (p_person_id_group is null))

Line 333: FROM igs_pe_prsid_grp_mem pgm

329: aap.SS_ADM_APPL_ID = aa.SS_ADM_APPL_ID(+)
330: And ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
331: AND (p_person_id_group IS NOT NULL AND
332: aa.person_id IN (SELECT person_id
333: FROM igs_pe_prsid_grp_mem pgm
334: WHERE pgm.group_id = p_person_id_group
335: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
336: OR
337: (p_person_id_group is null))

Line 356: FROM igs_pe_prsid_grp_mem pgm

352: Where
353: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
354: AND (p_person_id_group IS NOT NULL AND
355: aa.person_id IN (SELECT person_id
356: FROM igs_pe_prsid_grp_mem pgm
357: WHERE pgm.group_id = p_person_id_group
358: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
359: OR
360: (p_person_id_group is null))

Line 406: FROM igs_pe_prsid_grp_mem pgm

402: Where
403: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
404: AND (p_person_id_group IS NOT NULL AND
405: aa.person_id IN (SELECT person_id
406: FROM igs_pe_prsid_grp_mem pgm
407: WHERE pgm.group_id = p_person_id_group
408: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
409: OR
410: (p_person_id_group is null))

Line 426: FROM igs_pe_prsid_grp_mem pgm

422: Where aap.SS_ADM_APPL_ID = aa.SS_ADM_APPL_ID(+)
423: And ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
424: AND (p_person_id_group IS NOT NULL AND
425: aa.person_id IN (SELECT person_id
426: FROM igs_pe_prsid_grp_mem pgm
427: WHERE pgm.group_id = p_person_id_group
428: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
429: OR
430: (p_person_id_group is null))

Line 448: FROM igs_pe_prsid_grp_mem pgm

444: Where
445: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
446: AND (p_person_id_group IS NOT NULL AND
447: aa.person_id IN (SELECT person_id
448: FROM igs_pe_prsid_grp_mem pgm
449: WHERE pgm.group_id = p_person_id_group
450: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
451: OR
452: (p_person_id_group is null))

Line 1107: p_person_id_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,

1103: PROCEDURE Adm_Application_Req
1104: ( errbuf OUT NOCOPY VARCHAR2,
1105: retcode OUT NOCOPY NUMBER ,
1106: p_person_id IN hz_parties.party_id%TYPE,
1107: p_person_id_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
1108: p_appl_id IN igs_ad_appl.application_id%Type,
1109: p_calendar_details IN VARCHAR2,
1110: p_tracking_type IN VARCHAR2,
1111: p_apc IN VARCHAR2,

Line 1150: FROM igs_pe_prsid_grp_mem pgm

1146: igs_tr_type_all ty
1147: where a.person_id = i.person_id
1148: and (p_person_id_group IS NOT NULL and
1149: a.person_id IN (SELECT person_id
1150: FROM igs_pe_prsid_grp_mem pgm
1151: WHERE pgm.group_id = nvl(p_person_id_group,pgm.group_id)
1152: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
1153: OR
1154: (p_person_id_group is null))

Line 1187: FROM igs_pe_prsid_grp_mem pgm

1183: igs_tr_type_all ty
1184: where a.person_id = i.person_id
1185: and (p_person_id_group IS NOT NULL and
1186: a.person_id IN (SELECT person_id
1187: FROM igs_pe_prsid_grp_mem pgm
1188: WHERE pgm.group_id = nvl(p_person_id_group,pgm.group_id)
1189: And SYSDATE BETWEEN nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE))
1190: OR
1191: (p_person_id_group is null))