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

1151: into l_delete_permitted
1152: from sys.dual
1153: where not exists (
1154: select null
1155: from pay_element_entries_f e,
1156: per_assignments_f a,
1157: pay_element_links_f l
1158: where a.person_id = P_PERSON_ID
1159: and a.assignment_id = e.assignment_id

Line 1183: from pay_element_entries_f e,

1179: into l_delete_permitted
1180: from sys.dual
1181: where not exists (
1182: select null
1183: from pay_element_entries_f e,
1184: per_assignments_f a
1185: where a.person_id = P_PERSON_ID
1186: and a.assignment_id = e.assignment_id
1187: and e.entry_type <> 'E');

Line 1592: from pay_element_entries_f e

1588: begin
1589: delete from pay_element_entry_values_f v
1590: where v.element_entry_id in
1591: (select e.element_entry_id
1592: from pay_element_entries_f e
1593: where e.assignment_id = l_assignment_id);
1594: exception
1595: when NO_DATA_FOUND then null;
1596: end;

Line 1607: from pay_element_entries_f e

1603: delete from pay_run_results r
1604: where r.source_type = 'E'
1605: and r.source_id in
1606: (select e.element_entry_id
1607: from pay_element_entries_f e
1608: where e.assignment_id = l_assignment_id);
1609: exception
1610: when NO_DATA_FOUND then null;
1611: end;

Line 1618: delete from pay_element_entries_f e

1614: hr_utility.set_location(l_proc, 120);
1615: end if;
1616: --
1617: begin
1618: delete from pay_element_entries_f e
1619: where e.assignment_id = l_assignment_id;
1620: exception
1621: when NO_DATA_FOUND then null;
1622: end;

Line 3217: from pay_element_entries_f e

3213: --
3214: delete from pay_element_entry_values_f v
3215: where v.element_entry_id in
3216: (select e.element_entry_id
3217: from pay_element_entries_f e
3218: where exists
3219: (select null
3220: from per_assignments_f ass
3221: where ass.assignment_id = e.assignment_id

Line 3242: from pay_element_entries_f e

3238: delete from pay_run_results r
3239: where r.source_type = 'E'
3240: and r.source_id in
3241: (select e.element_entry_id
3242: from pay_element_entries_f e
3243: where exists
3244: (select null
3245: from per_assignments_f ass
3246: where ass.assignment_id = e.assignment_id

Line 3263: delete from pay_element_entries_f e

3259: end if;
3260: --
3261: begin
3262: --
3263: delete from pay_element_entries_f e
3264: where e.assignment_id in
3265: (select ass.assignment_id
3266: from per_assignments_f ass
3267: where ass.person_id = P_PERSON_ID);