APPS.HR_PERSON_DELETE dependencies on PAY_ELEMENT_ENTRIES_F

Line 65: 80.5 (70.8) 11-AUG-94 JRHODES #226211 Changed del from pay_element_entries_f

61: installed multiple times
62: (3) don't return 'Y' if install status
63: is 'S'
64: - wwbug 210697
65: 80.5 (70.8) 11-AUG-94 JRHODES #226211 Changed del from pay_element_entries_f
66: to improve performance
67: 70.9 01-FEB-95 JRHODES Delete PER_PAY_PROPOSALS (G1773)
68: 70.10 06-APR-95 JRHODES Bug 271369
69: Use effective_start_date in

Line 447: from pay_element_entries_f e,

443: select l.element_type_id,
444: e.effective_start_date,
445: e.effective_end_date,
446: a.assignment_id
447: from pay_element_entries_f e,
448: per_assignments_f a,
449: pay_element_links_f l
450: where a.person_id = P_PERSON_ID
451: and a.assignment_id = e.assignment_id

Line 974: from pay_element_entries_f e,

970: into v_delete_permitted
971: from sys.dual
972: where not exists (
973: select null
974: from pay_element_entries_f e,
975: per_assignments_f a,
976: pay_element_links_f l
977: where a.person_id = P_PERSON_ID
978: and a.assignment_id = e.assignment_id

Line 998: from pay_element_entries_f e,

994: into v_delete_permitted
995: from sys.dual
996: where not exists (
997: select null
998: from pay_element_entries_f e,
999: per_assignments_f a
1000: where a.person_id = P_PERSON_ID
1001: and a.assignment_id = e.assignment_id
1002: and e.entry_type <> 'E');

Line 2458: from pay_element_entries_f e

2454: begin
2455: delete from pay_element_entry_values_f v
2456: where v.element_entry_id in (
2457: select e.element_entry_id
2458: from pay_element_entries_f e
2459: where exists (
2460: select null
2461: from per_assignments_f ass
2462: where ass.assignment_id = e.assignment_id

Line 2477: from pay_element_entries_f e

2473: delete from pay_run_results r
2474: where r.source_type = 'E'
2475: and r.source_id in (
2476: select e.element_entry_id
2477: from pay_element_entries_f e
2478: where exists (
2479: select null
2480: from per_assignments_f ass
2481: where ass.assignment_id = e.assignment_id

Line 2492: delete from pay_element_entries_f e

2488: --
2489: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 38);
2490: --
2491: begin
2492: delete from pay_element_entries_f e
2493: where e.assignment_id in (
2494: select ass.assignment_id
2495: from per_assignments_f ass
2496: where ass.person_id = P_PERSON_ID);

Line 2927: from pay_element_entries_f e

2923: begin
2924: delete from pay_element_entry_values_f v
2925: where exists (
2926: select null
2927: from pay_element_entries_f e
2928: where e.assignment_id = V_ASSIGNMENT_ID
2929: and e.element_entry_id = v.element_entry_id);
2930: exception
2931: when NO_DATA_FOUND then null;

Line 2941: from pay_element_entries_f e

2937: delete from pay_run_results r
2938: where r.source_type = 'E'
2939: and EXISTS (
2940: select null
2941: from pay_element_entries_f e
2942: where e.assignment_id = V_ASSIGNMENT_ID
2943: and e.element_entry_id = r.source_id);
2944: exception
2945: when NO_DATA_FOUND then null;

Line 2951: delete from pay_element_entries_f e

2947: --
2948: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 11);
2949: --
2950: begin
2951: delete from pay_element_entries_f e
2952: where e.assignment_id = V_ASSIGNMENT_ID;
2953: exception
2954: when NO_DATA_FOUND then null;
2955: end;