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.HR_PERSON_DELETE dependencies on PER_COBRA_COVERAGE_BENEFITS

Line 2013: delete from per_cobra_coverage_benefits c2

2009: -- must be deleted first as PER_COBRA_COV_ENROLLMENTS has a
2010: -- contact_relationship_id which may be constrained later.
2011: --
2012: begin
2013: delete from per_cobra_coverage_benefits c2
2014: where c2.cobra_coverage_enrollment_id in (
2015: select c.cobra_coverage_enrollment_id
2016: from per_cobra_cov_enrollments c
2017: where exists (

Line 2031: delete from per_cobra_coverage_benefits c2

2027: --
2028: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 230);
2029: --
2030: begin
2031: delete from per_cobra_coverage_benefits c2
2032: where c2.cobra_coverage_enrollment_id in (
2033: select c.cobra_coverage_enrollment_id
2034: from per_cobra_cov_enrollments c
2035: , per_contact_relationships r