APPS.PN_SPACE_ASSIGN_EMP_PKG dependencies on DUAL

Line 120: FROM DUAL;

116: IF (x_emp_space_assign_id IS NULL) THEN
117:
118: SELECT pn_space_assign_emp_s.NEXTVAL
119: INTO x_emp_space_assign_id
120: FROM DUAL;
121: END IF;
122:
123: INSERT INTO pn_space_assign_emp_all
124: (

Line 514: FROM DUAL;

510:
511:
512: SELECT pn_space_assign_emp_s.NEXTVAL
513: INTO l_emp_space_assign_id
514: FROM DUAL;
515:
516: INSERT INTO pn_space_assign_emp_all
517: (
518: emp_space_assign_id,

Line 729: FROM DUAL

725: ORDER BY active_start_date;
726:
727: CURSOR check_loctn_gap(l_date IN DATE) IS
728: SELECT 'Y'
729: FROM DUAL
730: WHERE NOT EXISTS (SELECT NULL
731: FROM pn_locations_all
732: WHERE l_date BETWEEN active_start_date AND active_end_date
733: AND location_id = p_loc_id);

Line 777: FROM DUAL;

773:
774: SELECT loctn_tab(i+1).active_start_date -
775: loctn_tab(i).active_end_date
776: INTO l_diff
777: FROM DUAL;
778:
779: IF l_diff > 1 THEN
780: l_err_flag := 'Y';
781: EXIT;

Line 822: FROM DUAL

818: l_err_flag VARCHAR2(1) := 'N';
819:
820: CURSOR check_emp_assignment IS
821: SELECT 'Y'
822: FROM DUAL
823: WHERE EXISTS (SELECT NULL
824: FROM pn_space_assign_emp_all
825: WHERE person_id = p_person_id
826: AND location_id = p_loc_id

Line 834: FROM DUAL

830: >= p_assgn_str_dt);
831:
832: CURSOR check_ccd_assignment IS
833: SELECT 'Y'
834: FROM DUAL
835: WHERE EXISTS (SELECT NULL
836: FROM pn_space_assign_emp_all
837: WHERE cost_center_code = p_cost_cntr_code
838: AND location_id = p_loc_id