APPS.HR_PERSON_INTERNAL dependencies on PAY_ELEMENT_ENTRIES_F

Line 226: FROM pay_element_entries_f e,

222: --
223: CURSOR csr_this_persons_ee IS
224: SELECT l.element_type_id, e.effective_start_date,
225: e.effective_end_date, a.assignment_id
226: FROM pay_element_entries_f e,
227: per_assignments_f a,
228: pay_element_links_f l
229: WHERE a.person_id = P_PERSON_ID
230: and a.assignment_id = e.assignment_id

Line 1184: from pay_element_entries_f e,

1180: into l_delete_permitted
1181: from sys.dual
1182: where not exists (
1183: select null
1184: from pay_element_entries_f e,
1185: per_assignments_f a,
1186: pay_element_links_f l
1187: where a.person_id = P_PERSON_ID
1188: and a.assignment_id = e.assignment_id

Line 1212: from pay_element_entries_f e,

1208: into l_delete_permitted
1209: from sys.dual
1210: where not exists (
1211: select null
1212: from pay_element_entries_f e,
1213: per_assignments_f a
1214: where a.person_id = P_PERSON_ID
1215: and a.assignment_id = e.assignment_id
1216: and e.entry_type <> 'E');

Line 1622: from pay_element_entries_f e

1618: begin
1619: delete from pay_element_entry_values_f v
1620: where v.element_entry_id in
1621: (select e.element_entry_id
1622: from pay_element_entries_f e
1623: where e.assignment_id = l_assignment_id);
1624: exception
1625: when NO_DATA_FOUND then null;
1626: end;

Line 1637: from pay_element_entries_f e

1633: delete from pay_run_results r
1634: where r.source_type = 'E'
1635: and r.source_id in
1636: (select e.element_entry_id
1637: from pay_element_entries_f e
1638: where e.assignment_id = l_assignment_id);
1639: exception
1640: when NO_DATA_FOUND then null;
1641: end;

Line 1648: delete from pay_element_entries_f e

1644: hr_utility.set_location(l_proc, 120);
1645: end if;
1646: --
1647: begin
1648: delete from pay_element_entries_f e
1649: where e.assignment_id = l_assignment_id;
1650: exception
1651: when NO_DATA_FOUND then null;
1652: end;

Line 3270: from pay_element_entries_f e

3266: --
3267: delete from pay_element_entry_values_f v
3268: where v.element_entry_id in
3269: (select e.element_entry_id
3270: from pay_element_entries_f e
3271: where exists
3272: (select null
3273: from per_assignments_f ass
3274: where ass.assignment_id = e.assignment_id

Line 3295: from pay_element_entries_f e

3291: delete from pay_run_results r
3292: where r.source_type = 'E'
3293: and r.source_id in
3294: (select e.element_entry_id
3295: from pay_element_entries_f e
3296: where exists
3297: (select null
3298: from per_assignments_f ass
3299: where ass.assignment_id = e.assignment_id

Line 3316: delete from pay_element_entries_f e

3312: end if;
3313: --
3314: begin
3315: --
3316: delete from pay_element_entries_f e
3317: where e.assignment_id in
3318: (select ass.assignment_id
3319: from per_assignments_f ass
3320: where ass.person_id = P_PERSON_ID);