APPS.PNT_LOCATIONS_PKG dependencies on DUAL

Line 1029: FROM DUAL

1025:
1026: --Modified the cursor for Bug 6827603
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

Line 1039: FROM DUAL) loc

1035: START WITH location_id = p_location_id
1036: CONNECT BY PRIOR location_id = parent_location_id
1037: UNION
1038: SELECT -1 loc_id
1039: FROM DUAL) loc
1040: WHERE p_asgn_mode IN ('ALL', 'CUST')
1041: AND ((p_location_type IN ('OFFICE', 'SECTION') AND
1042: location_id = p_location_id AND
1043: loc.loc_id=-1) OR

Line 1057: FROM DUAL) loc

1053: START WITH location_id = p_location_id
1054: CONNECT BY PRIOR location_id = parent_location_id
1055: UNION
1056: SELECT -1 loc_id
1057: FROM DUAL) loc
1058: WHERE p_asgn_mode IN ('ALL', 'EMP', 'CC')
1059: AND ((p_location_type IN ('OFFICE', 'SECTION') AND
1060: location_id = p_location_id AND
1061: loc.loc_id=-1) OR

Line 1116: FROM DUAL

1112: l_end_date DATE;
1113:
1114: CURSOR check_loc_status_csr IS
1115: SELECT 'TRUE'
1116: FROM DUAL
1117: WHERE EXISTS (SELECT NULL
1118: FROM pn_locations_all
1119: WHERE location_id = p_parent_location_id
1120: AND active_start_date <= l_end_date

Line 1470: FROM DUAL;

1466: -----------------------------------------------------------------
1467: IF x_change_mode IS NULL and x_location_id is null THEN
1468: SELECT pn_locations_s.NEXTVAL
1469: INTO x_location_id
1470: FROM DUAL;
1471: END IF;
1472:
1473: pnp_debug_pkg.debug(' InsRow> before insert' || x_change_mode);
1474: BEGIN

Line 3240: FROM DUAL

3236: ORDER BY active_start_date;
3237:
3238: CURSOR check_loctn_gap(l_date IN DATE) IS
3239: SELECT 'Y'
3240: FROM DUAL
3241: WHERE NOT EXISTS (SELECT NULL
3242: FROM pn_locations_all
3243: WHERE l_date BETWEEN active_start_date AND active_end_date
3244: AND location_id = p_loc_id

Line 3715: FROM DUAL

3711: l_dummy NUMBER;
3712:
3713: CURSOR loc_code_cur IS
3714: SELECT 1
3715: FROM DUAL
3716: WHERE EXISTS (SELECT 1
3717: FROM pn_locations_all pnl
3718: WHERE pnl.location_code = x_location_code
3719: AND pnl.active_start_date = x_active_start_date

Line 3766: FROM DUAL

3762: ) IS
3763: l_dummy NUMBER;
3764: CURSOR building_cur IS
3765: SELECT 1
3766: FROM DUAL
3767: WHERE EXISTS (SELECT 1
3768: FROM pn_locations_all pnl
3769: WHERE UPPER(pnl.building) = UPPER(x_building)
3770: AND ((x_location_id IS NULL) OR (pnl.location_id <> x_location_id))

Line 3868: FROM DUAL

3864: l_set_token VARCHAR2(30);
3865:
3866: CURSOR loc_alias_cur IS
3867: SELECT 1
3868: FROM DUAL
3869: WHERE EXISTS (SELECT 1
3870: FROM pn_locations_all pnl
3871: WHERE pnl.location_alias = x_location_alias
3872: AND location_type_lookup_code = x_location_type_lookup_code