APPS.IGS_PS_RLOVR_FAC_TSK dependencies on IGS_PS_FAC_ASG_TASK_V

Line 631: FROM igs_ps_fac_Asg_task_v

627: -- get all the assigned tasks for the faculty
628: --
629: CURSOR cur_source_tasks(cp_fac_wl_id igs_ps_fac_asg_task.fac_wl_id%TYPE) IS
630: SELECT *
631: FROM igs_ps_fac_Asg_task_v
632: WHERE fac_wl_id = cp_fac_wl_id AND
633: NVL(num_rollover_period,99) >= 1 ;
634:
635: --update the source task type to set rollover_flag='S'