855: IF (p_global_attribute3 IS NOT NULL) THEN
856: BEGIN
857: SELECT 'X'
858: INTO value_exists
859: FROM HR_Locations_all
860: WHERE Location_id = p_global_attribute3
861: AND sysdate < nvl(inactive_date, sysdate+1); -- Bug 3463869
862: EXCEPTION
863:
976: IF (p_global_attribute18 IS NOT NULL) THEN
977: BEGIN
978: SELECT 'X'
979: INTO value_exists
980: FROM HR_Locations_all
981: WHERE Location_id = p_global_attribute18
982: AND sysdate < nvl(inactive_date, sysdate+1); -- Bug 3463869
983: EXCEPTION
984:
1104: IF (p_global_attribute3 IS NOT NULL) THEN
1105: BEGIN
1106: SELECT 'X'
1107: INTO value_exists
1108: FROM HR_Locations_all
1109: WHERE Location_id = p_global_attribute3
1110: AND sysdate < nvl(inactive_date, sysdate+1); -- Bug 3463869
1111: EXCEPTION
1112: