APPS.GHR_PA_REQUESTS_PKG dependencies on HR_LOOKUPS

Line 101: ,p_lookup_type hr_lookups.lookup_type%TYPE

97: END get_restricted_process_method;
98:
99: FUNCTION get_lookup_meaning(
100: p_application_id NUMBER
101: ,p_lookup_type hr_lookups.lookup_type%TYPE
102: ,p_lookup_code hr_lookups.lookup_code%TYPE)
103: RETURN VARCHAR2 IS
104:
105: CURSOR cur_loc IS

Line 102: ,p_lookup_code hr_lookups.lookup_code%TYPE)

98:
99: FUNCTION get_lookup_meaning(
100: p_application_id NUMBER
101: ,p_lookup_type hr_lookups.lookup_type%TYPE
102: ,p_lookup_code hr_lookups.lookup_code%TYPE)
103: RETURN VARCHAR2 IS
104:
105: CURSOR cur_loc IS
106: SELECT loc.meaning

Line 107: FROM hr_lookups loc

103: RETURN VARCHAR2 IS
104:
105: CURSOR cur_loc IS
106: SELECT loc.meaning
107: FROM hr_lookups loc
108: WHERE loc.lookup_type = p_lookup_type
109: AND loc.lookup_code = p_lookup_code;
110:
111: BEGIN

Line 114: -- should use HR_LOOKUPS

110:
111: BEGIN
112: -- Previously this routine used to go directly in on FND_COMMON_LOOKUPS
113: -- now it assumes it was only used for types with application id 800 and hence
114: -- should use HR_LOOKUPS
115: IF p_application_id = 800 THEN
116: FOR cur_loc_rec IN cur_loc LOOP
117: RETURN(cur_loc_rec.meaning);
118: END LOOP;

Line 130: ,p_lookup_type hr_lookups.lookup_type%TYPE

126: END get_lookup_meaning;
127:
128: FUNCTION get_lookup_description(
129: p_application_id NUMBER
130: ,p_lookup_type hr_lookups.lookup_type%TYPE
131: ,p_lookup_code hr_lookups.lookup_code%TYPE)
132: RETURN VARCHAR2 IS
133:
134: CURSOR cur_loc IS

Line 131: ,p_lookup_code hr_lookups.lookup_code%TYPE)

127:
128: FUNCTION get_lookup_description(
129: p_application_id NUMBER
130: ,p_lookup_type hr_lookups.lookup_type%TYPE
131: ,p_lookup_code hr_lookups.lookup_code%TYPE)
132: RETURN VARCHAR2 IS
133:
134: CURSOR cur_loc IS
135: SELECT loc.description

Line 136: FROM hr_lookups loc

132: RETURN VARCHAR2 IS
133:
134: CURSOR cur_loc IS
135: SELECT loc.description
136: FROM hr_lookups loc
137: WHERE loc.lookup_type = p_lookup_type
138: AND loc.lookup_code = p_lookup_code;
139:
140: BEGIN

Line 143: -- should use HR_LOOKUPS

139:
140: BEGIN
141: -- Previously this routine used to go directly in on FND_COMMON_LOOKUPS
142: -- now it assumes it was only used for types with application id 800 and hence
143: -- should use HR_LOOKUPS
144: IF p_application_id = 800 THEN
145: FOR cur_loc_rec IN cur_loc LOOP
146: RETURN(cur_loc_rec.description);
147: END LOOP;

Line 1392: FROM hr_lookups hrl

1388:
1389: CURSOR cur_nla IS
1390: SELECT hrl.lookup_code
1391: ,hrl.description
1392: FROM hr_lookups hrl
1393: ,ghr_noac_las nla
1394: WHERE nla.nature_of_action_id = p_nature_of_action_id
1395: AND nla.enabled_flag = 'Y'
1396: AND nla.valid_first_lac_flag = 'Y'