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 HR_API_TRANSACTIONS

Line 1761: FROM hr_api_transactions a,

1757: WHERE person_id = P_PERSON_ID);
1758: DELETE
1759: FROM hr_api_transaction_steps
1760: WHERE transaction_id IN (SELECT a.transaction_id
1761: FROM hr_api_transactions a,
1762: per_personal_scorecards sc
1763: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1764: AND a.transaction_ref_id = sc.scorecard_id
1765: AND sc.person_id = P_PERSON_ID);

Line 1768: FROM hr_api_transactions

1764: AND a.transaction_ref_id = sc.scorecard_id
1765: AND sc.person_id = P_PERSON_ID);
1766:
1767: DELETE
1768: FROM hr_api_transactions
1769: WHERE transaction_id IN (SELECT transaction_id
1770: FROM hr_api_transactions a,
1771: per_personal_scorecards sc
1772: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'

Line 1770: FROM hr_api_transactions a,

1766:
1767: DELETE
1768: FROM hr_api_transactions
1769: WHERE transaction_id IN (SELECT transaction_id
1770: FROM hr_api_transactions a,
1771: per_personal_scorecards sc
1772: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1773: AND a.transaction_ref_id = sc.scorecard_id
1774: AND sc.person_id = P_PERSON_ID);