eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_SPACE_ASSIGN_EMP_PKG dependencies on PN_LOCATIONS_ALL

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 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