DBA Data[Home] [Help]

APPS.JL_INTERFACE_VAL dependencies on HR_LOCATIONS_ALL

Line 859: FROM HR_Locations_all

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:

Line 980: FROM HR_Locations_all

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:

Line 1108: FROM HR_Locations_all

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: