DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PER_PERSON_TYPES

Line 1478: from per_person_types ppt,

1474: --
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'

Line 1480: per_person_types_tl ptl

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
1484: and ppt.active_flag = 'Y'