eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ASSIGNMENT_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 1538: per_person_type_usages_f ptu,

1534: Is
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

Line 1629: delete from per_person_type_usages_f ptu

1625: --
1626: -- - Remove all benefits assignment related PTUs
1627: -- for the person of the benefits assignment
1628: --
1629: delete from per_person_type_usages_f ptu
1630: where ptu.person_id in
1631: (select asg.person_id
1632: from per_all_assignments_f asg
1633: where asg.assignment_id = p_assignment_id