DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on HR_LEG_LOOKUPS

Line 2372: hr_leg_lookups hl

2368: --
2369: cursor c_get_mapping_name6(p_id in number,p_id1 in number,p_date in date) is
2370: select hl.meaning name
2371: from per_abs_attendance_reasons abr,
2372: hr_leg_lookups hl
2373: where abr.business_group_id = p_business_group_id
2374: and abr.absence_attendance_type_id = p_id
2375: and abr.abs_attendance_reason_id = p_id1
2376: and abr.name = hl.lookup_code

Line 2725: hr_leg_lookups hrlkup,

2721: --
2722: cursor c_get_person_type_name(p_person_typ_id in number) is
2723: select ptl.user_person_type
2724: from per_person_types ppt,
2725: hr_leg_lookups hrlkup,
2726: per_person_types_tl ptl
2727: where active_flag = 'Y'
2728: -- and business_group_id = p_business_group_id
2729: and hrlkup.lookup_type = 'PERSON_TYPE'