APPS.PNT_LOCATIONS_PKG dependencies on PN_SPACE_ASSIGN_EMP_ALL

Line 1049: FROM pn_space_assign_emp_all, (SELECT location_id loc_id

1045: location_id =loc.loc_id))
1046: AND cust_assign_start_date <= l_end_date
1047: AND NVL(cust_assign_end_date, TO_DATE('12/31/4712','MM/DD/YYYY')) >= l_str_date)
1048: OR EXISTS (SELECT NULL
1049: FROM pn_space_assign_emp_all, (SELECT location_id loc_id
1050: FROM pn_locations_all
1051: WHERE active_start_date <= l_end_date
1052: AND active_end_date >= l_str_date
1053: START WITH location_id = p_location_id

Line 2494: FROM pn_space_assign_emp_all

2490: (SELECT location_id, active_start_date,active_end_date
2491: FROM pn_locations_all pl
2492: WHERE active_start_date > p_active_end_date
2493: AND NOT EXISTS (SELECT '1'
2494: FROM pn_space_assign_emp_all
2495: WHERE location_id = pl.location_id
2496: AND p_active_end_date BETWEEN emp_assign_start_date
2497: AND emp_assign_end_date)
2498: AND NOT EXISTS (SELECT '1'

Line 2539: FROM pn_space_assign_emp_all

2535: (SELECT location_id, active_start_date,active_end_date
2536: FROM pn_locations_all pl
2537: WHERE active_end_date < p_active_start_date
2538: AND NOT EXISTS (SELECT '1'
2539: FROM pn_space_assign_emp_all
2540: WHERE location_id = pl.location_id
2541: AND p_active_start_date BETWEEN emp_assign_start_date
2542: AND emp_assign_end_date)
2543: AND NOT EXISTS (SELECT '1'

Line 2998: DELETE FROM pn_space_assign_emp_all

2994: and p_active_end_date <> p_active_end_date_old THEN
2995:
2996: pnp_debug_pkg.debug(' UpdAsgn> Inside end date updation');
2997:
2998: DELETE FROM pn_space_assign_emp_all
2999: WHERE location_id = l_location_rec.location_id
3000: AND emp_assign_start_date > p_active_end_date
3001: AND allocated_area = 0;
3002:

Line 3003: UPDATE pn_space_assign_emp_all

2999: WHERE location_id = l_location_rec.location_id
3000: AND emp_assign_start_date > p_active_end_date
3001: AND allocated_area = 0;
3002:
3003: UPDATE pn_space_assign_emp_all
3004: SET emp_assign_end_date = p_active_end_date
3005: WHERE location_id = l_location_rec.location_id
3006: AND emp_assign_end_date > p_active_end_date;
3007:

Line 3025: DELETE FROM pn_space_assign_emp_all

3021: and p_active_start_date <> p_active_start_date_old THEN
3022:
3023: pnp_debug_pkg.debug(' UpdAsgn> Inside start date updation');
3024:
3025: DELETE FROM pn_space_assign_emp_all
3026: WHERE location_id = l_location_rec.location_id
3027: AND emp_assign_end_date < p_active_start_date
3028: AND allocated_area = 0;
3029:

Line 3030: UPDATE pn_space_assign_emp_all

3026: WHERE location_id = l_location_rec.location_id
3027: AND emp_assign_end_date < p_active_start_date
3028: AND allocated_area = 0;
3029:
3030: UPDATE pn_space_assign_emp_all
3031: SET emp_assign_start_date = p_active_start_date
3032: WHERE location_id = l_location_rec.location_id
3033: AND emp_assign_start_date < p_active_start_date;
3034: