APPS.PN_SPACE_ASSIGN_EMP_PKG dependencies on PN_LOCATIONS

Line 67: FROM pn_locations_all

63: l_asgn_mode VARCHAR2(30);
64:
65: CURSOR org_cur IS
66: SELECT org_id
67: FROM pn_locations_all
68: WHERE location_id = x_location_id;
69:
70: l_org_id NUMBER;
71:

Line 695: -- 01-JUL-05 hrodda o Bug 4284035 - Replaced pn_locations

691: -- History :
692: -- 27-DEC-02 Mrinal Misra o Mrinal Misra
693: -- 10-JAN-03 Mrinal Misra o Modified to run FOR LOOP one lesser
694: -- count by 1..loctn_tab.count-1.
695: -- 01-JUL-05 hrodda o Bug 4284035 - Replaced pn_locations
696: -- with _ALL table.
697: -------------------------------------------------------------------------------
698: PROCEDURE check_office_assign_gaps(p_loc_id IN NUMBER,
699: p_str_dt IN DATE,

Line 703: location_id pn_locations.location_id%TYPE,

699: p_str_dt IN DATE,
700: p_end_dt IN DATE) IS
701:
702: TYPE loctn_rec IS RECORD(
703: location_id pn_locations.location_id%TYPE,
704: active_start_date DATE,
705: active_end_date DATE);
706:
707: TYPE loc_type IS

Line 721: FROM pn_locations_all

717: CURSOR get_loctn_dates IS
718: SELECT location_id,
719: active_start_date,
720: active_end_date
721: FROM pn_locations_all
722: WHERE active_end_date >= p_str_dt
723: AND active_start_date <= p_end_dt
724: AND location_id = p_loc_id
725: ORDER BY active_start_date;

Line 731: FROM pn_locations_all

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);
734:
735: BEGIN