APPS.PA_OTC_API dependencies on HR_LOCATIONS

Line 6627: from hr_locations l

6623:
6624:
6625: Cursor GetLocationInfo(P_Location_Id IN Pa_Expenditure_Items_All.Location_Id%TYPE) IS
6626: select l.location_code
6627: from hr_locations l
6628: where location_id = P_Location_Id
6629: and p_exp_item_date <= nvl(l.inactive_date, p_exp_item_date)
6630: and l.location_use = 'HR';
6631:

Line 6632: l_location_code hr_locations.location_code%TYPE := Null;

6628: where location_id = P_Location_Id
6629: and p_exp_item_date <= nvl(l.inactive_date, p_exp_item_date)
6630: and l.location_use = 'HR';
6631:
6632: l_location_code hr_locations.location_code%TYPE := Null;
6633:
6634: Begin
6635:
6636: G_Stage := 'Entering procedure Validate_Location_Exists().';