DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on PER_PERSON_TYPE_USAGES_F

Line 1541: from per_person_type_usages_f per,

1537: ppt.person_type_id,
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

Line 1550: -- this person type id may not exist in per_person_type_usages_f. So this

1546: and per.effective_end_date
1547: and per.person_type_id = ppt.person_type_id
1548: --
1549: -- This person_type_id is the original person type id. It is possible that
1550: -- this person type id may not exist in per_person_type_usages_f. So this
1551: -- data should not be used for profiles evaluation.
1552: --
1553: /* union
1554: select ppf.person_id,