DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on HR_LEG_LOOKUPS

Line 1301: hr_leg_lookups hl

1297: cv_effective_date date) is
1298: select hl.meaning name,
1299: abr.abs_attendance_reason_id id
1300: from per_abs_attendance_reasons abr,
1301: hr_leg_lookups hl
1302: where abr.name = hl.lookup_code and
1303: hl.lookup_type = 'ABSENCE_REASON' and
1304: hl.enabled_flag = 'Y'
1305: and meaning = p_source_name1

Line 1479: hr_leg_lookups hrlkup,

1475: cursor c_PersonTypeNameLovVO(p_source_name1 varchar2) is
1476: select ptl.user_person_type name,
1477: ppt.person_type_id id
1478: from per_person_types ppt,
1479: hr_leg_lookups hrlkup,
1480: per_person_types_tl ptl
1481: where active_flag = 'Y' and
1482: hrlkup.lookup_type = 'PERSON_TYPE'
1483: and hrlkup.lookup_code = ppt.system_person_type