APPS.BEN_ASSIGNMENT_API dependencies on PER_PERSON_TYPES

Line 261: select ptu.person_type_id from per_person_type_usages_f ptu,per_person_types ppt where

257: and active_flag = 'Y';
258:
259: /* Bug 7597322: Added cursor to get the person_type_id on benefits assignment creation date*/
260: cursor c_ptyp_id is
261: select ptu.person_type_id from per_person_type_usages_f ptu,per_person_types ppt where
262: ptu.person_id=p_person_id
263: and ppt.person_type_id=ptu.person_type_id
264: and ppt.system_person_type='EMP'
265: and l_effective_date between ptu.effective_start_date and ptu.effective_end_date;

Line 1567: per_person_types pet

1563: select ptu.person_type_usage_id,
1564: ptu.object_version_number
1565: from per_all_assignments_f asg,
1566: per_person_type_usages_f ptu,
1567: per_person_types pet
1568: where ptu.person_id = asg.person_id
1569: and asg.assignment_type <> 'C'
1570: and ptu.person_type_id = pet.person_type_id
1571: and c_eff_date

Line 1665: from per_person_types pet

1661: where asg.assignment_id = p_assignment_id
1662: )
1663: and ptu.person_type_id in
1664: (select pet.person_type_id
1665: from per_person_types pet
1666: where pet.SYSTEM_PERSON_TYPE
1667: in('SRVNG_SPS'
1668: ,'FRMR_SPS'
1669: ,'SRVNG_FMLY_MMBR'