DBA Data[Home] [Help]

APPS.BEN_ASSIGNMENT_API dependencies on PER_PERSON_TYPES

Line 1539: per_person_types pet

1535: select ptu.person_type_usage_id,
1536: ptu.object_version_number
1537: from per_all_assignments_f asg,
1538: per_person_type_usages_f ptu,
1539: per_person_types pet
1540: where ptu.person_id = asg.person_id
1541: and asg.assignment_type <> 'C'
1542: and ptu.person_type_id = pet.person_type_id
1543: and c_eff_date

Line 1637: from per_person_types pet

1633: where asg.assignment_id = p_assignment_id
1634: )
1635: and ptu.person_type_id in
1636: (select pet.person_type_id
1637: from per_person_types pet
1638: where pet.SYSTEM_PERSON_TYPE
1639: in('SRVNG_SPS'
1640: ,'FRMR_SPS'
1641: ,'SRVNG_FMLY_MMBR'