APPS.HRWSECI dependencies on HR_LOOKUPS

Line 155: hr_lookups HR1,

151: CURSOR C1 IS
152: SELECT CCP.coverage,
153: CCP.coverage_uom
154: FROM per_cobra_coverage_periods CCP,
155: hr_lookups HR1,
156: hr_lookups HR2,
157: hr_lookups HR3
158: WHERE CCP.qualifying_event = p_qualifying_event
159: AND CCP.type_code = p_type_code

Line 156: hr_lookups HR2,

152: SELECT CCP.coverage,
153: CCP.coverage_uom
154: FROM per_cobra_coverage_periods CCP,
155: hr_lookups HR1,
156: hr_lookups HR2,
157: hr_lookups HR3
158: WHERE CCP.qualifying_event = p_qualifying_event
159: AND CCP.type_code = p_type_code
160: AND HR1.lookup_type = 'US_COBRA_EVENT'

Line 157: hr_lookups HR3

153: CCP.coverage_uom
154: FROM per_cobra_coverage_periods CCP,
155: hr_lookups HR1,
156: hr_lookups HR2,
157: hr_lookups HR3
158: WHERE CCP.qualifying_event = p_qualifying_event
159: AND CCP.type_code = p_type_code
160: AND HR1.lookup_type = 'US_COBRA_EVENT'
161: AND HR1.lookup_code = CCP.qualifying_event

Line 531: FROM hr_lookups l

527: -- decalre cursor to get meaning
528: --
529: CURSOR await_meaning IS
530: SELECT meaning
531: FROM hr_lookups l
532: WHERE lookup_type = 'US_COBRA_STATUS'
533: AND lookup_code = 'AWAIT';
534: --
535: BEGIN

Line 1381: FROM hr_lookups h,

1377: CURSOR latest_status_info IS
1378: SELECT ccs.cobra_coverage_status_type,
1379: ccs.effective_date,
1380: h.meaning
1381: FROM hr_lookups h,
1382: per_cobra_coverage_statuses ccs
1383: WHERE ccs.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
1384: AND ccs.cobra_coverage_status_id =
1385: (SELECT MAX(ccs1.cobra_coverage_status_id)