APPS.IGS_PS_GEN_001 dependencies on IGS_PS_FAC_ASG_TASK

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