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_TENANCIES_PKG dependencies on PN_SPACE_ASSIGN_EMP_ALL

Line 1528: FROM pn_space_assign_emp_all

1524: CURSOR csr_emp_info IS
1525: SELECT emp_assign_start_date,
1526: NVL(emp_assign_end_date, p_to_date) emp_assign_end_date,
1527: allocated_area
1528: FROM pn_space_assign_emp_all
1529: WHERE location_id = p_location_id
1530: AND emp_assign_start_date <= p_to_date
1531: AND NVL(emp_assign_end_date, p_to_date) >= p_from_date;
1532:

Line 3205: FROM pn_space_assign_emp_all

3201: CURSOR csr_emp_info IS
3202: SELECT emp_assign_start_date,
3203: NVL(emp_assign_end_date, p_to_date) emp_assign_end_date,
3204: nvl(allocated_area,0) allocated_area
3205: FROM pn_space_assign_emp_all
3206: WHERE location_id = p_location_id
3207: AND emp_assign_start_date <= p_to_date
3208: AND NVL(emp_assign_end_date, p_to_date) >= p_from_date;
3209: