APPS.PNT_LOCATIONS_PKG dependencies on PN_SPACE_ASSIGN_CUST_ALL

Line 1031: FROM pn_space_assign_cust_all, (SELECT location_id loc_id

1027: CURSOR check_assign_csr IS
1028: SELECT 'TRUE'
1029: FROM DUAL
1030: WHERE EXISTS (SELECT NULL
1031: FROM pn_space_assign_cust_all, (SELECT location_id loc_id
1032: FROM pn_locations_all
1033: WHERE active_start_date <= l_end_date
1034: AND active_end_date >= l_str_date
1035: START WITH location_id = p_location_id

Line 2499: FROM pn_space_assign_cust_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'
2499: FROM pn_space_assign_cust_all
2500: WHERE location_id = pl.location_id
2501: AND p_active_end_date BETWEEN cust_assign_start_date
2502: AND cust_assign_end_date)
2503: START WITH location_id = p_location_id

Line 2544: FROM pn_space_assign_cust_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'
2544: FROM pn_space_assign_cust_all
2545: WHERE location_id = pl.location_id
2546: AND p_active_start_date BETWEEN cust_assign_start_date
2547: AND cust_assign_end_date)
2548: START WITH location_id = p_location_id

Line 3008: DELETE FROM pn_space_assign_cust_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:
3008: DELETE FROM pn_space_assign_cust_all
3009: WHERE location_id = l_location_rec.location_id
3010: AND cust_assign_start_date > p_active_end_date
3011: AND allocated_area = 0;
3012:

Line 3013: UPDATE pn_space_assign_cust_all

3009: WHERE location_id = l_location_rec.location_id
3010: AND cust_assign_start_date > p_active_end_date
3011: AND allocated_area = 0;
3012:
3013: UPDATE pn_space_assign_cust_all
3014: SET cust_assign_end_date = p_active_end_date
3015: WHERE location_id = l_location_rec.location_id
3016: AND cust_assign_end_date > p_active_end_date;
3017:

Line 3035: DELETE FROM pn_space_assign_cust_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:
3035: DELETE FROM pn_space_assign_cust_all
3036: WHERE location_id = l_location_rec.location_id
3037: AND cust_assign_end_date < p_active_start_date
3038: AND allocated_area = 0;
3039:

Line 3040: UPDATE pn_space_assign_cust_all

3036: WHERE location_id = l_location_rec.location_id
3037: AND cust_assign_end_date < p_active_start_date
3038: AND allocated_area = 0;
3039:
3040: UPDATE pn_space_assign_cust_all
3041: SET cust_assign_start_date = p_active_start_date
3042: WHERE location_id = l_location_rec.location_id
3043: AND cust_assign_start_date < p_active_start_date;
3044: