DBA Data[Home] [Help]

APPS.JTF_CAL_SHIFT_CONSTRUCTS_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 591: FROM jtf_task_assignments

587:
588: PROCEDURE delete_row(x_error OUT NOCOPY VARCHAR2, x_shift_construct_id IN NUMBER) IS
589: CURSOR c_sh_exist_in_task_assmt(p_shift_cons_id NUMBER) IS
590: SELECT 1
591: FROM jtf_task_assignments
592: WHERE shift_construct_id = p_shift_cons_id AND ROWNUM = 1;
593:
594: l_exists NUMBER := NULL;
595: v_error VARCHAR2(1) := 'N';