DBA Data[Home] [Help]

APPS.HXC_TIMECARD_HOURS_PKG dependencies on HR_LOOKUPS

Line 36: hr_lookups hl,

32: CURSOR csr_element_ids(p_lookup_type VARCHAR2) IS
33: select
34: petf.element_type_id element_type_id
35: from
36: hr_lookups hl,
37: pay_element_types_f petf
38: where
39: upper(petf.element_name) = hl.lookup_code
40: and hl.lookup_type = p_lookup_type

Line 231: hr_lookups hl,

227: CURSOR csr_element_ids(p_lookup_type VARCHAR2) IS
228: select
229: petf.element_type_id element_type_id
230: from
231: hr_lookups hl,
232: pay_element_types_f petf
233: where
234: upper(petf.element_name) = hl.lookup_code
235: and hl.lookup_type = p_lookup_type