DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on HR_API_TRANSACTIONS

Line 3817: FROM hr_api_transactions a,

3813: WHERE person_id = P_PERSON_ID);
3814: DELETE
3815: FROM hr_api_transaction_steps
3816: WHERE transaction_id IN (SELECT a.transaction_id
3817: FROM hr_api_transactions a,
3818: per_personal_scorecards sc
3819: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
3820: AND a.transaction_ref_id = sc.scorecard_id
3821: AND sc.person_id = P_PERSON_ID);

Line 3824: FROM hr_api_transactions

3820: AND a.transaction_ref_id = sc.scorecard_id
3821: AND sc.person_id = P_PERSON_ID);
3822:
3823: DELETE
3824: FROM hr_api_transactions
3825: WHERE transaction_id IN (SELECT transaction_id
3826: FROM hr_api_transactions a,
3827: per_personal_scorecards sc
3828: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'

Line 3826: FROM hr_api_transactions a,

3822:
3823: DELETE
3824: FROM hr_api_transactions
3825: WHERE transaction_id IN (SELECT transaction_id
3826: FROM hr_api_transactions a,
3827: per_personal_scorecards sc
3828: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
3829: AND a.transaction_ref_id = sc.scorecard_id
3830: AND sc.person_id = P_PERSON_ID);