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_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 4438: FROM igs_ps_fac_wl fw,igs_ps_fac_asg_task fat

4434: cp_c_cal_type igs_ca_inst.cal_type%TYPE,
4435: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE
4436: ) IS
4437: SELECT NVL(SUM(NVL(fat.default_wl,0)),0)
4438: FROM igs_ps_fac_wl fw,igs_ps_fac_asg_task fat
4439: WHERE fw.person_id = cp_n_person_id AND
4440: fat.fac_wl_id = fw.fac_wl_id AND
4441: fw.cal_type = cp_c_cal_type AND
4442: fw.ci_sequence_number=cp_n_cal_seq_num AND