DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on PER_PERSON_TYPES

Line 1576: per_person_types ppt

1572: ppt.user_person_type,
1573: ppt.system_person_type,
1574: decode(ppt.system_person_type,'EMP',1,2)
1575: from per_person_type_usages_f per,
1576: per_person_types ppt
1577: where per.person_id = p_person_id
1578: and p_effective_date
1579: between per.effective_start_date
1580: and per.effective_end_date

Line 1592: per_person_types ppt

1588: ppt.user_person_type,
1589: ppt.system_person_type,
1590: decode(ppt.system_person_type,'EMP',1,2)
1591: from per_all_people_f ppf,
1592: per_person_types ppt
1593: where ppf.person_id = p_person_id
1594: and p_effective_date
1595: between ppf.effective_start_date
1596: and ppf.effective_end_date

Line 1614: per_person_types ppt

1610: ppt.user_person_type,
1611: ppt.system_person_type,
1612: decode(ppt.system_person_type,'EMP',1,2)
1613: from per_all_people_f ppf,
1614: per_person_types ppt
1615: where ppf.person_id = p_person_id
1616: and p_effective_date
1617: between ppf.effective_start_date
1618: and ppf.effective_end_date