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_HE_EXTRACT_PKG dependencies on IGS_PE_PRSID_GRP_MEM_ALL

Line 303: -- Changed the cursor to replace the multi org view with igs_pe_prsid_grp_mem_all for bug,3179585

299: OR only IS NOT NULL)
300: AND param_type IN ('PSN_IDENT_GROUP', 'PSN_ID')
301: ORDER BY param_type;
302:
303: -- Changed the cursor to replace the multi org view with igs_pe_prsid_grp_mem_all for bug,3179585
304: -- smaddali modified this cursor to select group_cd instead of group_id for bug2391473
305: --smaddali modified this cursor to add new parameter p_group_cd for bug 2436567
306: -- smaddali modified this cursor to get records which are effective in the HESA submission period, bug#3235753
307: CURSOR c_psn_grp

Line 314: igs_pe_prsid_grp_mem_all b

310: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
311: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
312: SELECT a.group_cd
313: FROM igs_pe_persid_group a ,
314: igs_pe_prsid_grp_mem_all b
315: WHERE b.person_id = p_person_id
316: AND a.group_cd = p_group_cd
317: AND ( b.Start_Date IS NULL OR b.Start_Date <= cp_enrl_end_dt)
318: AND ( b.End_Date IS NULL OR b.End_Date >= cp_enrl_start_dt )