DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on PER_PERSON_TYPES

Line 1542: per_person_types ppt

1538: ppt.user_person_type,
1539: ppt.system_person_type,
1540: decode(ppt.system_person_type,'EMP',1,2)
1541: from per_person_type_usages_f per,
1542: per_person_types ppt
1543: where per.person_id = p_person_id
1544: and p_effective_date
1545: between per.effective_start_date
1546: and per.effective_end_date

Line 1560: per_person_types ppt

1556: ppt.user_person_type,
1557: ppt.system_person_type,
1558: decode(ppt.system_person_type,'EMP',1,2)
1559: from per_all_people_f ppf,
1560: per_person_types ppt
1561: where ppf.person_id = p_person_id
1562: and p_effective_date
1563: between ppf.effective_start_date
1564: and ppf.effective_end_date