APPS.HR_PERSON_INTERNAL dependencies on PER_PERSONAL_SCORECARDS

Line 3803: FROM per_personal_scorecards

3799: BEGIN
3800: DELETE
3801: FROM per_objectives
3802: WHERE scorecard_id IN (SELECT scorecard_id
3803: FROM per_personal_scorecards
3804: WHERE person_id = P_PERSON_ID)
3805: OR appraisal_id in (SELECT appraisal_id
3806: FROM per_appraisals
3807: WHERE appraisee_person_id = p_person_id) ;

Line 3812: FROM per_personal_scorecards

3808:
3809: DELETE
3810: FROM per_scorecard_sharing
3811: WHERE scorecard_id IN (SELECT scorecard_id
3812: FROM per_personal_scorecards
3813: WHERE person_id = P_PERSON_ID);
3814: DELETE
3815: FROM hr_api_transaction_steps
3816: WHERE transaction_id IN (SELECT a.transaction_id

Line 3818: per_personal_scorecards sc

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);
3822:

Line 3819: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'

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);
3822:
3823: DELETE

Line 3827: per_personal_scorecards sc

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);
3831: DELETE

Line 3828: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'

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);
3831: DELETE
3832: FROM per_personal_scorecards

Line 3832: FROM per_personal_scorecards

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);
3831: DELETE
3832: FROM per_personal_scorecards
3833: WHERE person_id = P_PERSON_ID;
3834:
3835: EXCEPTION
3836: WHEN Others Then