eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERSON_DELETE dependencies on PER_ASSIGNMENTS_F

Line 316: per_assignments_f ass,

312: from sys.dual
313: where not exists (
314: select null
315: from pay_assignment_actions paa,
316: per_assignments_f ass,
317: pay_payroll_actions ppa
318: where paa.assignment_id = ass.assignment_id
319: and ass.person_id = P_PERSON_ID
320: and ppa.payroll_action_id = paa.payroll_action_id

Line 407: from per_assignments_f ass,

403: into v_delete_permitted
404: from sys.dual
405: where not exists (
406: select null
407: from per_assignments_f ass,
408: hr_assignment_set_amendments asa
409: where asa.assignment_id = ass.assignment_id
410: and ass.person_id = P_PERSON_ID
411: and asa.include_or_exclude = 'I'

Line 447: per_assignments_f a,

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
451: and e.effective_start_date between

Line 497: from per_assignments_f a

493: into v_delete_permitted
494: from sys.dual
495: where not exists (
496: select null
497: from per_assignments_f a
498: , per_contact_relationships c
499: , per_cobra_cov_enrollments e
500: where a.person_id = P_PERSON_ID
501: and a.assignment_id = e.assignment_id

Line 706: from per_assignments_f a

702: select null
703: from per_letter_request_lines r
704: where exists (
705: select null
706: from per_assignments_f a
707: where a.person_id = P_PERSON_ID
708: and a.effective_start_date >= P_SESSION_DATE
709: and a.assignment_id = r.assignment_id));
710:

Line 722: from per_assignments_f a

718: where r.person_id = P_PERSON_ID
719: and r.date_from >= P_SESSION_DATE
720: or exists (
721: select null
722: from per_assignments_f a
723: where a.person_id = P_PERSON_ID
724: and a.effective_start_date >= P_SESSION_DATE
725: and a.assignment_id = r.assignment_id));*/
726:

Line 792: from per_assignments_f a

788: into v_delete_permitted
789: from sys.dual
790: where 1 >= (
791: select count(*)
792: from per_assignments_f a
793: where a.person_id = P_PERSON_ID
794: and a.effective_start_date > P_SESSION_DATE);-- fix for bug 4238025
795: exception
796: when NO_DATA_FOUND then

Line 809: from per_assignments_f a

805: into v_delete_permitted
806: from sys.dual
807: where not exists (
808: select null
809: from per_assignments_f a
810: where a.recruiter_id = P_PERSON_ID
811: or a.supervisor_id = P_PERSON_ID);
812: exception
813: when NO_DATA_FOUND then

Line 974: per_assignments_f a,

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
978: and e.element_link_id = l.element_link_id

Line 998: per_assignments_f a

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');
1002: exception

Line 1025: from per_assignments_f a

1021: select null
1022: from per_assignment_extra_info i
1023: where exists (
1024: select null
1025: from per_assignments_f a
1026: where a.person_id = P_PERSON_ID
1027: and a.assignment_id = i.assignment_id));
1028: exception
1029: when NO_DATA_FOUND then

Line 1045: from per_assignments_f a

1041: select null
1042: from per_secondary_ass_statuses s
1043: where exists (
1044: select null
1045: from per_assignments_f a
1046: where a.person_id = P_PERSON_ID
1047: and a.assignment_id = s.assignment_id));
1048: exception
1049: when NO_DATA_FOUND then

Line 1066: from per_assignments_f a

1062: select null
1063: from per_events e
1064: where exists (
1065: select null
1066: from per_assignments_f a
1067: where a.person_id = P_PERSON_ID
1068: and a.assignment_id = e.assignment_id));
1069: exception
1070: when NO_DATA_FOUND then

Line 1086: from per_assignments_f a

1082: select null
1083: from per_spinal_point_placements_f p
1084: where exists (
1085: select null
1086: from per_assignments_f a
1087: where a.person_id = P_PERSON_ID
1088: and a.assignment_id = p.assignment_id));
1089: exception
1090: when NO_DATA_FOUND then

Line 1106: from per_assignments_f a

1102: select null
1103: from per_quickpaint_result_text t
1104: where exists (
1105: select null
1106: from per_assignments_f a
1107: where a.person_id = P_PERSON_ID
1108: and a.assignment_id = t.assignment_id));
1109: exception
1110: when NO_DATA_FOUND then

Line 1126: from per_assignments_f a

1122: select null
1123: from per_cobra_cov_enrollments c
1124: where exists (
1125: select null
1126: from per_assignments_f a
1127: where a.person_id = P_PERSON_ID
1128: and a.assignment_id = c.assignment_id));
1129: exception
1130: when NO_DATA_FOUND then

Line 1418: from per_assignments_f

1414: FOR UPDATE;
1415: --
1416: cursor LOCK_ASSIGNMENT_ROWS is
1417: select assignment_id
1418: from per_assignments_f
1419: where person_id = P_PERSON_ID
1420: FOR UPDATE;
1421: --
1422: cursor DELETE_COMPONENTS is

Line 1425: per_assignments_f pa

1421: --
1422: cursor DELETE_COMPONENTS is
1423: select pp.pay_proposal_id
1424: from per_pay_proposals pp,
1425: per_assignments_f pa
1426: where pa.person_id = P_PERSON_ID
1427: and pa.assignment_id = pp.assignment_id
1428: FOR UPDATE;
1429: --

Line 1488: from per_assignments_f

1484: l_assignment_id assignmentid;
1485:
1486: Cursor c_asg is
1487: select distinct assignment_id
1488: from per_assignments_f
1489: where person_id = p_person_id;
1490: -- bug fix 3732129 ends here.
1491:
1492: BEGIN

Line 1548: from per_assignments_f a

1544: delete from per_letter_request_lines l
1545: where l.person_id = P_PERSON_ID
1546: or exists (
1547: select null
1548: from per_assignments_f a
1549: where a.person_id = P_PERSON_ID
1550: and a.assignment_id = l.assignment_id);*/
1551: exception
1552: when NO_DATA_FOUND then

Line 1605: -- per_assignments_f.

1601: --
1602: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 8);
1603: --
1604: -- Delete of per_periods_of_service at end after delete of
1605: -- per_assignments_f.
1606: --
1607: begin
1608: update per_periods_of_service p
1609: set p.termination_accepted_person_id = null

Line 1815: update per_assignments_f ass

1811: --
1812: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 15);
1813: --
1814: begin
1815: update per_assignments_f ass
1816: set ass.person_referred_by_id = null
1817: where ass.person_referred_by_id = P_PERSON_ID;
1818: exception
1819: when NO_DATA_FOUND then

Line 1826: update per_assignments_f a

1822: --
1823: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 16);
1824: --
1825: begin
1826: update per_assignments_f a
1827: set a.recruiter_id = null
1828: where a.recruiter_id = P_PERSON_ID;
1829: exception
1830: when NO_DATA_FOUND then

Line 1837: update per_assignments_f a

1833: --
1834: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 17);
1835: --
1836: begin
1837: update per_assignments_f a
1838: set a.supervisor_id = null
1839: where a.supervisor_id = P_PERSON_ID;
1840: exception
1841: when NO_DATA_FOUND then

Line 1875: from per_assignments_f ass

1871: --
1872: delete from per_pay_proposals p
1873: where exists (
1874: select null
1875: from per_assignments_f ass
1876: where ass.assignment_id = p.assignment_id
1877: and ass.person_id = P_PERSON_ID);
1878: exception
1879: when NO_DATA_FOUND then

Line 1889: from per_assignments_f ass

1885: begin
1886: delete from pay_personal_payment_methods_f m
1887: where m.assignment_id in (
1888: select ass.assignment_id
1889: from per_assignments_f ass
1890: where ass.person_id = P_PERSON_ID);
1891: exception
1892: when NO_DATA_FOUND then
1893: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 1901);

Line 1902: from per_assignments_f ass

1898: begin
1899: delete from per_assignment_budget_values_f a
1900: where a.assignment_id in (
1901: select ass.assignment_id
1902: from per_assignments_f ass
1903: where ass.person_id = P_PERSON_ID);
1904: exception
1905: when NO_DATA_FOUND then
1906: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2001);

Line 1915: from per_assignments_f ass

1911: begin
1912: delete from per_assignment_extra_info a
1913: where a.assignment_id in (
1914: select ass.assignment_id
1915: from per_assignments_f ass
1916: where ass.person_id = P_PERSON_ID);
1917: exception
1918: when NO_DATA_FOUND then
1919: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2101);

Line 1928: from per_assignments_f ass

1924: begin
1925: delete from per_secondary_ass_statuses a
1926: where a.assignment_id in (
1927: select ass.assignment_id
1928: from per_assignments_f ass
1929: where ass.person_id = P_PERSON_ID);
1930: exception
1931: when NO_DATA_FOUND then
1932: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2201);

Line 1948: from per_assignments_f ass

1944: select c.cobra_coverage_enrollment_id
1945: from per_cobra_cov_enrollments c
1946: where exists (
1947: select null
1948: from per_assignments_f ass
1949: where ass.assignment_id = c.assignment_id
1950: and ass.person_id = P_PERSON_ID)
1951: );
1952: exception

Line 1969: from per_assignments_f ass

1965: where r.contact_person_id = P_PERSON_ID
1966: and c.contact_relationship_id = r.contact_relationship_id
1967: and exists (
1968: select null
1969: from per_assignments_f ass
1970: where ass.assignment_id = c.assignment_id
1971: and ass.person_id = r.person_id)
1972: );
1973: exception

Line 1987: from per_assignments_f ass

1983: select c.cobra_coverage_enrollment_id
1984: from per_cobra_cov_enrollments c
1985: where exists (
1986: select null
1987: from per_assignments_f ass
1988: where ass.assignment_id = c.assignment_id
1989: and ass.person_id = P_PERSON_ID)
1990: );
1991: exception

Line 2008: from per_assignments_f ass

2004: where r.contact_person_id = P_PERSON_ID
2005: and c.contact_relationship_id = r.contact_relationship_id
2006: and exists (
2007: select null
2008: from per_assignments_f ass
2009: where ass.assignment_id = c.assignment_id
2010: and ass.person_id = r.person_id)
2011: );
2012: exception

Line 2026: from per_assignments_f ass

2022: select c.cobra_coverage_enrollment_id
2023: from per_cobra_cov_enrollments c
2024: where exists (
2025: select null
2026: from per_assignments_f ass
2027: where ass.assignment_id = c.assignment_id
2028: and ass.person_id = P_PERSON_ID)
2029: );
2030: exception

Line 2047: from per_assignments_f ass

2043: where r.contact_person_id = P_PERSON_ID
2044: and c.contact_relationship_id = r.contact_relationship_id
2045: and exists (
2046: select null
2047: from per_assignments_f ass
2048: where ass.assignment_id = c.assignment_id
2049: and ass.person_id = r.person_id)
2050: );
2051: exception

Line 2062: from per_assignments_f ass

2058: begin
2059: delete from per_cobra_cov_enrollments c
2060: where c.assignment_id in (
2061: select ass.assignment_id
2062: from per_assignments_f ass
2063: where ass.person_id = P_PERSON_ID);
2064: exception
2065: when NO_DATA_FOUND then
2066: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 23501);

Line 2080: from per_assignments_f ass

2076: where r.contact_person_id = P_PERSON_ID
2077: and c.contact_relationship_id = r.contact_relationship_id
2078: and exists (
2079: select null
2080: from per_assignments_f ass
2081: where ass.assignment_id = c.assignment_id
2082: and ass.person_id = r.person_id)
2083: );
2084: exception

Line 2225: from per_assignments_f ass

2221: (select e.event_id
2222: from per_events e
2223: where exists (
2224: select null
2225: from per_assignments_f ass
2226: where ass.assignment_id = e.assignment_id
2227: and ass.person_id = P_PERSON_ID)
2228: );*/
2229: exception

Line 2247: from per_assignments_f ass

2243:
2244: /* delete from per_events e
2245: where e.assignment_id in (
2246: select ass.assignment_id
2247: from per_assignments_f ass
2248: where ass.person_id = P_PERSON_ID);*/
2249: exception
2250: when NO_DATA_FOUND then
2251: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 26201);

Line 2281: from per_assignments_f ass

2277: begin
2278: delete from per_quickpaint_result_text q
2279: where q.assignment_id in (
2280: select ass.assignment_id
2281: from per_assignments_f ass
2282: where ass.person_id = P_PERSON_ID);
2283: exception
2284: when NO_DATA_FOUND then
2285: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2901);

Line 2297: from per_assignments_f ass

2293: begin
2294: delete from hr_assignment_set_amendments h
2295: where h.assignment_id in (
2296: select ass.assignment_id
2297: from per_assignments_f ass
2298: where ass.person_id = P_PERSON_ID);
2299: exception
2300: when NO_DATA_FOUND then
2301: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 3001);

Line 2310: from per_assignments_f ass

2306: begin
2307: delete from pay_cost_allocations_f a
2308: where a.assignment_id in (
2309: select ass.assignment_id
2310: from per_assignments_f ass
2311: where ass.person_id = P_PERSON_ID);
2312: exception
2313: when NO_DATA_FOUND then
2314: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 3101);

Line 2323: from per_assignments_f ass

2319: begin
2320: delete from per_spinal_point_placements_f p
2321: where p.assignment_id in (
2322: select ass.assignment_id
2323: from per_assignments_f ass
2324: where ass.person_id = P_PERSON_ID);
2325: exception
2326: when NO_DATA_FOUND then
2327: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 3201);

Line 2339: from per_assignments_f ass

2335: begin
2336: delete from pay_assignment_actions a
2337: where exists (
2338: select null
2339: from per_assignments_f ass
2340: where ass.person_id = P_PERSON_ID
2341: and ass.assignment_id = a.assignment_id);
2342: exception
2343: when NO_DATA_FOUND then

Line 2353: from per_assignments_f ass

2349: begin
2350: delete from pay_assignment_latest_balances b
2351: where b.assignment_id in (
2352: select ass.assignment_id
2353: from per_assignments_f ass
2354: where ass.person_id = P_PERSON_ID);
2355: exception
2356: when NO_DATA_FOUND then
2357: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 3401);

Line 2374: from per_assignments_f ass

2370: /*delete from pay_assignment_link_usages_f u
2371: where
2372: u.assignment_id in (
2373: select ass.assignment_id
2374: from per_assignments_f ass
2375: where ass.person_id = P_PERSON_ID); */
2376: exception
2377: when NO_DATA_FOUND then
2378: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 3501);

Line 2390: from per_assignments_f ass

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
2392: and ass.person_id = P_PERSON_ID)
2393: );
2394: exception

Line 2409: from per_assignments_f ass

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
2411: and ass.person_id = P_PERSON_ID)
2412: );
2413: exception

Line 2424: from per_assignments_f ass

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);
2426: exception
2427: when NO_DATA_FOUND then
2428: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 3801);

Line 2443: from per_assignments_f ass

2439:
2440: Delete pay_us_emp_fed_tax_rules_f peft
2441: Where peft.assignment_id in (
2442: select ass.assignment_id
2443: from per_assignments_f ass
2444: where ass.person_id = p_person_id );
2445: exception
2446: when no_data_found then
2447: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON',3802);

Line 2457: from per_assignments_f ass

2453:
2454: Delete pay_us_emp_state_tax_rules_f pest
2455: Where pest.assignment_id in (
2456: select ass.assignment_id
2457: from per_assignments_f ass
2458: where ass.person_id = p_person_id );
2459: exception
2460: when no_data_found then
2461: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON',3803);

Line 2471: from per_assignments_f ass

2467:
2468: Delete pay_us_emp_county_tax_rules_f pect
2469: Where pect.assignment_id in (
2470: select ass.assignment_id
2471: from per_assignments_f ass
2472: where ass.person_id = p_person_id );
2473: exception
2474: when no_data_found then
2475: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON',3804);

Line 2485: from per_assignments_f ass

2481:
2482: Delete pay_us_emp_city_tax_rules_f pecit
2483: Where pecit.assignment_id in (
2484: select ass.assignment_id
2485: from per_assignments_f ass
2486: where ass.person_id = p_person_id );
2487: exception
2488: when no_data_found then
2489: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON',3805);

Line 2796: from per_assignments_f ass

2792: --
2793: begin
2794: select ass.assignment_id
2795: into v_assignment_id
2796: from per_assignments_f ass
2797: where ass.person_id = P_PERSON_ID
2798: FOR UPDATE;
2799: exception
2800: when NO_DATA_FOUND then null;

Line 2890: delete from per_assignments_f ass

2886: --
2887: -- No exception, should succeed.
2888: --
2889: begin
2890: delete from per_assignments_f ass
2891: where ass.assignment_id = V_ASSIGNMENT_ID;
2892: end;
2893: --
2894: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 13);

Line 3005: from per_assignments_f ass

3001: --
3002: begin
3003: select ass.assignment_id
3004: into v_assignment_id
3005: from per_assignments_f ass
3006: where ass.person_id = P_PERSON_ID
3007: FOR UPDATE;
3008: end;
3009: --

Line 3032: delete from per_assignments_f ass

3028: --
3029: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 7);
3030: --
3031: begin
3032: delete from per_assignments_f ass
3033: where ass.assignment_id = V_ASSIGNMENT_ID;
3034: end;
3035: --
3036: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 8);