APPS.HR_RU_LOCATION_HOOK dependencies on HR_LOCATIONS_ALL

Line 42: l_loc_information13 hr_locations_all.loc_information13%TYPE;

38: )
39: AS
40: l_proc CONSTANT VARCHAR2 (72)
41: := g_package || 'UPDATE_RU_LOCATION';
42: l_loc_information13 hr_locations_all.loc_information13%TYPE;
43: l_postal_code hr_locations_all.postal_code%TYPE;
44: l_style hr_locations_all.style%TYPE;
45:
46: CURSOR csr_get_location_details (p_id NUMBER)

Line 43: l_postal_code hr_locations_all.postal_code%TYPE;

39: AS
40: l_proc CONSTANT VARCHAR2 (72)
41: := g_package || 'UPDATE_RU_LOCATION';
42: l_loc_information13 hr_locations_all.loc_information13%TYPE;
43: l_postal_code hr_locations_all.postal_code%TYPE;
44: l_style hr_locations_all.style%TYPE;
45:
46: CURSOR csr_get_location_details (p_id NUMBER)
47: IS

Line 44: l_style hr_locations_all.style%TYPE;

40: l_proc CONSTANT VARCHAR2 (72)
41: := g_package || 'UPDATE_RU_LOCATION';
42: l_loc_information13 hr_locations_all.loc_information13%TYPE;
43: l_postal_code hr_locations_all.postal_code%TYPE;
44: l_style hr_locations_all.style%TYPE;
45:
46: CURSOR csr_get_location_details (p_id NUMBER)
47: IS
48: SELECT style, loc_information13, postal_code

Line 49: FROM hr_locations_all

45:
46: CURSOR csr_get_location_details (p_id NUMBER)
47: IS
48: SELECT style, loc_information13, postal_code
49: FROM hr_locations_all
50: WHERE location_id = p_id;
51:
52: l_location_record csr_get_location_details%ROWTYPE;
53: BEGIN