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 446: from pay_element_entries_f e,

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

Line 973: from pay_element_entries_f e,

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

Line 997: from pay_element_entries_f e,

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

Line 2387: from pay_element_entries_f e

2383: begin
2384: delete from pay_element_entry_values_f v
2385: where v.element_entry_id in (
2386: select e.element_entry_id
2387: from pay_element_entries_f e
2388: where exists (
2389: select null
2390: from per_assignments_f ass
2391: where ass.assignment_id = e.assignment_id

Line 2406: from pay_element_entries_f e

2402: delete from pay_run_results r
2403: where r.source_type = 'E'
2404: and r.source_id in (
2405: select e.element_entry_id
2406: from pay_element_entries_f e
2407: where exists (
2408: select null
2409: from per_assignments_f ass
2410: where ass.assignment_id = e.assignment_id

Line 2421: delete from pay_element_entries_f e

2417: --
2418: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 38);
2419: --
2420: begin
2421: delete from pay_element_entries_f e
2422: where e.assignment_id in (
2423: select ass.assignment_id
2424: from per_assignments_f ass
2425: where ass.person_id = P_PERSON_ID);

Line 2855: from pay_element_entries_f e

2851: begin
2852: delete from pay_element_entry_values_f v
2853: where exists (
2854: select null
2855: from pay_element_entries_f e
2856: where e.assignment_id = V_ASSIGNMENT_ID
2857: and e.element_entry_id = v.element_entry_id);
2858: exception
2859: when NO_DATA_FOUND then null;

Line 2869: from pay_element_entries_f e

2865: delete from pay_run_results r
2866: where r.source_type = 'E'
2867: and EXISTS (
2868: select null
2869: from pay_element_entries_f e
2870: where e.assignment_id = V_ASSIGNMENT_ID
2871: and e.element_entry_id = r.source_id);
2872: exception
2873: when NO_DATA_FOUND then null;

Line 2879: delete from pay_element_entries_f e

2875: --
2876: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 11);
2877: --
2878: begin
2879: delete from pay_element_entries_f e
2880: where e.assignment_id = V_ASSIGNMENT_ID;
2881: exception
2882: when NO_DATA_FOUND then null;
2883: end;