APPS.PER_COBRA_ECI dependencies on HR_LOOKUPS

Line 183: -- hr_lookups HR1, -- BUG3804891

179: CURSOR C1 IS
180: SELECT CCP.coverage,
181: CCP.coverage_uom
182: FROM per_cobra_coverage_periods CCP
183: -- hr_lookups HR1, -- BUG3804891
184: -- hr_lookups HR2, -- BUG3804891
185: -- hr_lookups HR3 -- BUG3804891
186: WHERE CCP.qualifying_event = p_qualifying_event
187: AND CCP.type_code = p_type_code

Line 184: -- hr_lookups HR2, -- BUG3804891

180: SELECT CCP.coverage,
181: CCP.coverage_uom
182: FROM per_cobra_coverage_periods CCP
183: -- hr_lookups HR1, -- BUG3804891
184: -- hr_lookups HR2, -- BUG3804891
185: -- hr_lookups HR3 -- BUG3804891
186: WHERE CCP.qualifying_event = p_qualifying_event
187: AND CCP.type_code = p_type_code
188: --AND HR1.lookup_type = 'US_COBRA_EVENT' -- BUG3804891

Line 185: -- hr_lookups HR3 -- BUG3804891

181: CCP.coverage_uom
182: FROM per_cobra_coverage_periods CCP
183: -- hr_lookups HR1, -- BUG3804891
184: -- hr_lookups HR2, -- BUG3804891
185: -- hr_lookups HR3 -- BUG3804891
186: WHERE CCP.qualifying_event = p_qualifying_event
187: AND CCP.type_code = p_type_code
188: --AND HR1.lookup_type = 'US_COBRA_EVENT' -- BUG3804891
189: --AND HR1.lookup_code = CCP.qualifying_event -- BUG3804891

Line 574: FROM hr_lookups l

570: -- decalre cursor to get meaning
571: --
572: CURSOR await_meaning IS
573: SELECT meaning
574: FROM hr_lookups l
575: WHERE lookup_type = 'US_COBRA_STATUS'
576: AND lookup_code = 'AWAIT';
577: --
578: BEGIN

Line 1866: FROM hr_lookups h,

1862: CURSOR latest_status_info IS
1863: SELECT ccs.cobra_coverage_status_type,
1864: ccs.effective_date,
1865: h.meaning
1866: FROM hr_lookups h,
1867: per_cobra_coverage_statuses ccs
1868: WHERE ccs.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
1869: AND ccs.cobra_coverage_status_id =
1870: (SELECT MAX(ccs1.cobra_coverage_status_id)