APPS.HR_PERSON_DELETE dependencies on PER_QUALIFICATIONS

Line 154: 115.22 06-AUG-2001 rvydyana 1844844 Added per_qualifications to the delete

150: delete_person_type_usage
151: 115.21 30-Aug-2001 rvydyana added PTU call for default applicant delete
152: note : no ptu delete reqd in default
153: person delete procedure as it is not used
154: 115.22 06-AUG-2001 rvydyana 1844844 Added per_qualifications to the delete
155: list.
156: 115.23 22-FEB-2002 rmonge 1686922 Added code to delete tax records from
157: pay_us_emp_fed_tax_rules_f
158: pay_us_emp_state_tax_rules_f

Line 168: 115.26 03-DEC-2002 pmfletch MLS Added delete from per_qualifications_tl

164: the WHENEVER OSERROR EXIT FAILURE
165: ROLLBACK
166: 115.25 03-DEC-2002 pmfletch MLS Added delete from per_subjects_taken_tl
167: for MLS
168: 115.26 03-DEC-2002 pmfletch MLS Added delete from per_qualifications_tl
169: for MLS
170: 115.27 16-JUL-2003 jpthomas 3026024 Added delete from ben_covered_dependents_f.
171: Delete the entry in the above table for the
172: contact person whom is getting deleted.

Line 2689: , per_qualifications q

2685: --PMFLETCH Added delete from tl table
2686: delete from per_subjects_taken_tl st
2687: where st.subjects_taken_id IN ( select s.subjects_taken_id
2688: from per_subjects_taken s
2689: , per_qualifications q
2690: where q.person_id = P_PERSON_ID
2691: and s.qualification_id = q.qualification_id
2692: );
2693:

Line 2699: from per_qualifications

2695:
2696:
2697: delete from per_subjects_taken s
2698: where s.qualification_id in ( select qualification_id
2699: from per_qualifications
2700: where person_id = P_PERSON_ID );
2701:
2702: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4699);
2703:

Line 2705: delete from per_qualifications_tl qt

2701:
2702: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4699);
2703:
2704: --PMFLETCH Added delete from tl table
2705: delete from per_qualifications_tl qt
2706: where qt.qualification_id in ( select q.qualification_id
2707: from per_qualifications q
2708: where q.person_id = P_PERSON_ID
2709: );

Line 2707: from per_qualifications q

2703:
2704: --PMFLETCH Added delete from tl table
2705: delete from per_qualifications_tl qt
2706: where qt.qualification_id in ( select q.qualification_id
2707: from per_qualifications q
2708: where q.person_id = P_PERSON_ID
2709: );
2710:
2711: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4700);

Line 2713: delete from per_qualifications q

2709: );
2710:
2711: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4700);
2712:
2713: delete from per_qualifications q
2714: where q.person_id = P_PERSON_ID;
2715:
2716: exception
2717: when NO_DATA_FOUND then