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_PS_GEN_001 dependencies on IGS_PS_FAC_OVR_WL

Line 4423: FROM igs_ps_fac_wl fw,igs_ps_fac_ovr_wl fow

4419: cp_c_cal_type igs_ca_inst.cal_type%TYPE,
4420: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE
4421: ) IS
4422: SELECT NVL(fow.new_exp_wl,0)
4423: FROM igs_ps_fac_wl fw,igs_ps_fac_ovr_wl fow
4424: WHERE fw.person_id = cp_n_person_id AND
4425: fow.fac_wl_id = fw.fac_wl_id AND
4426: fw.cal_type = cp_c_cal_type AND
4427: fw.ci_sequence_number=cp_n_cal_seq_num AND

Line 4430: l_n_fac_ovr_wl igs_ps_fac_ovr_wl.new_exp_wl%TYPE:=0;

4426: fw.cal_type = cp_c_cal_type AND
4427: fw.ci_sequence_number=cp_n_cal_seq_num AND
4428: SYSDATE BETWEEN fow.start_date AND NVL(fow.end_date,SYSDATE);
4429:
4430: l_n_fac_ovr_wl igs_ps_fac_ovr_wl.new_exp_wl%TYPE:=0;
4431:
4432: /* Cursor to get sum of workload from assigned workload */
4433: CURSOR c_fac_assign_wl(cp_n_person_id hz_parties.party_id%TYPE,
4434: cp_c_cal_type igs_ca_inst.cal_type%TYPE,