DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on HR_LEG_LOOKUPS

Line 6419: hr_leg_lookups hl

6415:
6416: cursor c_get_mapping_name8(p_id in number,p_id1 in number,p_date in date) is
6417: select hl.meaning name
6418: from per_abs_attendance_reasons abr,
6419: hr_leg_lookups hl
6420: where abr.business_group_id = p_business_group_id
6421: and abr.absence_attendance_type_id = p_id
6422: and abr.abs_attendance_reason_id = p_id1
6423: and abr.name = hl.lookup_code

Line 6650: hr_leg_lookups hrlkup,

6646: --
6647: cursor c_get_person_type_name(p_person_typ_id in number) is
6648: select ptl.user_person_type
6649: from per_person_types ppt,
6650: hr_leg_lookups hrlkup,
6651: per_person_types_tl ptl
6652: where active_flag = 'Y'
6653: -- and business_group_id = p_business_group_id
6654: and hrlkup.lookup_type = 'PERSON_TYPE'