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 317: per_assignments_f ass,

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

Line 408: from per_assignments_f ass,

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

Line 448: per_assignments_f a,

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

Line 498: from per_assignments_f a

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

Line 707: from per_assignments_f a

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

Line 723: from per_assignments_f a

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

Line 793: from per_assignments_f a

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

Line 810: from per_assignments_f a

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

Line 975: per_assignments_f a,

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

Line 999: per_assignments_f a

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

Line 1026: from per_assignments_f a

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

Line 1046: from per_assignments_f a

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

Line 1067: from per_assignments_f a

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

Line 1087: from per_assignments_f a

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

Line 1107: from per_assignments_f a

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

Line 1127: from per_assignments_f a

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

Line 1419: from per_assignments_f

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

Line 1426: per_assignments_f pa

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

Line 1489: from per_assignments_f

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

Line 1549: from per_assignments_f a

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

Line 1606: -- per_assignments_f.

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

Line 1886: update per_assignments_f ass

1882: --
1883: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 15);
1884: --
1885: begin
1886: update per_assignments_f ass
1887: set ass.person_referred_by_id = null
1888: where ass.person_referred_by_id = P_PERSON_ID;
1889: exception
1890: when NO_DATA_FOUND then

Line 1897: update per_assignments_f a

1893: --
1894: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 16);
1895: --
1896: begin
1897: update per_assignments_f a
1898: set a.recruiter_id = null
1899: where a.recruiter_id = P_PERSON_ID;
1900: exception
1901: when NO_DATA_FOUND then

Line 1908: update per_assignments_f a

1904: --
1905: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 17);
1906: --
1907: begin
1908: update per_assignments_f a
1909: set a.supervisor_id = null
1910: where a.supervisor_id = P_PERSON_ID;
1911: exception
1912: when NO_DATA_FOUND then

Line 1946: from per_assignments_f ass

1942: --
1943: delete from per_pay_proposals p
1944: where exists (
1945: select null
1946: from per_assignments_f ass
1947: where ass.assignment_id = p.assignment_id
1948: and ass.person_id = P_PERSON_ID);
1949: exception
1950: when NO_DATA_FOUND then

Line 1960: from per_assignments_f ass

1956: begin
1957: delete from pay_personal_payment_methods_f m
1958: where m.assignment_id in (
1959: select ass.assignment_id
1960: from per_assignments_f ass
1961: where ass.person_id = P_PERSON_ID);
1962: exception
1963: when NO_DATA_FOUND then
1964: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 1901);

Line 1973: from per_assignments_f ass

1969: begin
1970: delete from per_assignment_budget_values_f a
1971: where a.assignment_id in (
1972: select ass.assignment_id
1973: from per_assignments_f ass
1974: where ass.person_id = P_PERSON_ID);
1975: exception
1976: when NO_DATA_FOUND then
1977: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2001);

Line 1986: from per_assignments_f ass

1982: begin
1983: delete from per_assignment_extra_info a
1984: where a.assignment_id in (
1985: select ass.assignment_id
1986: from per_assignments_f ass
1987: where ass.person_id = P_PERSON_ID);
1988: exception
1989: when NO_DATA_FOUND then
1990: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2101);

Line 1999: from per_assignments_f ass

1995: begin
1996: delete from per_secondary_ass_statuses a
1997: where a.assignment_id in (
1998: select ass.assignment_id
1999: from per_assignments_f ass
2000: where ass.person_id = P_PERSON_ID);
2001: exception
2002: when NO_DATA_FOUND then
2003: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2201);

Line 2019: from per_assignments_f ass

2015: select c.cobra_coverage_enrollment_id
2016: from per_cobra_cov_enrollments c
2017: where exists (
2018: select null
2019: from per_assignments_f ass
2020: where ass.assignment_id = c.assignment_id
2021: and ass.person_id = P_PERSON_ID)
2022: );
2023: exception

Line 2040: from per_assignments_f ass

2036: where r.contact_person_id = P_PERSON_ID
2037: and c.contact_relationship_id = r.contact_relationship_id
2038: and exists (
2039: select null
2040: from per_assignments_f ass
2041: where ass.assignment_id = c.assignment_id
2042: and ass.person_id = r.person_id)
2043: );
2044: exception

Line 2058: from per_assignments_f ass

2054: select c.cobra_coverage_enrollment_id
2055: from per_cobra_cov_enrollments c
2056: where exists (
2057: select null
2058: from per_assignments_f ass
2059: where ass.assignment_id = c.assignment_id
2060: and ass.person_id = P_PERSON_ID)
2061: );
2062: exception

Line 2079: from per_assignments_f ass

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

Line 2097: from per_assignments_f ass

2093: select c.cobra_coverage_enrollment_id
2094: from per_cobra_cov_enrollments c
2095: where exists (
2096: select null
2097: from per_assignments_f ass
2098: where ass.assignment_id = c.assignment_id
2099: and ass.person_id = P_PERSON_ID)
2100: );
2101: exception

Line 2118: from per_assignments_f ass

2114: where r.contact_person_id = P_PERSON_ID
2115: and c.contact_relationship_id = r.contact_relationship_id
2116: and exists (
2117: select null
2118: from per_assignments_f ass
2119: where ass.assignment_id = c.assignment_id
2120: and ass.person_id = r.person_id)
2121: );
2122: exception

Line 2133: from per_assignments_f ass

2129: begin
2130: delete from per_cobra_cov_enrollments c
2131: where c.assignment_id in (
2132: select ass.assignment_id
2133: from per_assignments_f ass
2134: where ass.person_id = P_PERSON_ID);
2135: exception
2136: when NO_DATA_FOUND then
2137: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 23501);

Line 2151: from per_assignments_f ass

2147: where r.contact_person_id = P_PERSON_ID
2148: and c.contact_relationship_id = r.contact_relationship_id
2149: and exists (
2150: select null
2151: from per_assignments_f ass
2152: where ass.assignment_id = c.assignment_id
2153: and ass.person_id = r.person_id)
2154: );
2155: exception

Line 2296: from per_assignments_f ass

2292: (select e.event_id
2293: from per_events e
2294: where exists (
2295: select null
2296: from per_assignments_f ass
2297: where ass.assignment_id = e.assignment_id
2298: and ass.person_id = P_PERSON_ID)
2299: );*/
2300: exception

Line 2318: from per_assignments_f ass

2314:
2315: /* delete from per_events e
2316: where e.assignment_id in (
2317: select ass.assignment_id
2318: from per_assignments_f ass
2319: where ass.person_id = P_PERSON_ID);*/
2320: exception
2321: when NO_DATA_FOUND then
2322: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 26201);

Line 2352: from per_assignments_f ass

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

Line 2368: from per_assignments_f ass

2364: begin
2365: delete from hr_assignment_set_amendments h
2366: where h.assignment_id in (
2367: select ass.assignment_id
2368: from per_assignments_f ass
2369: where ass.person_id = P_PERSON_ID);
2370: exception
2371: when NO_DATA_FOUND then
2372: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 3001);

Line 2381: from per_assignments_f ass

2377: begin
2378: delete from pay_cost_allocations_f a
2379: where a.assignment_id in (
2380: select ass.assignment_id
2381: from per_assignments_f ass
2382: where ass.person_id = P_PERSON_ID);
2383: exception
2384: when NO_DATA_FOUND then
2385: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 3101);

Line 2394: from per_assignments_f ass

2390: begin
2391: delete from per_spinal_point_placements_f p
2392: where p.assignment_id in (
2393: select ass.assignment_id
2394: from per_assignments_f ass
2395: where ass.person_id = P_PERSON_ID);
2396: exception
2397: when NO_DATA_FOUND then
2398: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 3201);

Line 2410: from per_assignments_f ass

2406: begin
2407: delete from pay_assignment_actions a
2408: where exists (
2409: select null
2410: from per_assignments_f ass
2411: where ass.person_id = P_PERSON_ID
2412: and ass.assignment_id = a.assignment_id);
2413: exception
2414: when NO_DATA_FOUND then

Line 2424: from per_assignments_f ass

2420: begin
2421: delete from pay_assignment_latest_balances b
2422: where b.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', 3401);

Line 2445: from per_assignments_f ass

2441: /*delete from pay_assignment_link_usages_f u
2442: where
2443: u.assignment_id in (
2444: select ass.assignment_id
2445: from per_assignments_f ass
2446: where ass.person_id = P_PERSON_ID); */
2447: exception
2448: when NO_DATA_FOUND then
2449: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 3501);

Line 2461: from per_assignments_f ass

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
2463: and ass.person_id = P_PERSON_ID)
2464: );
2465: exception

Line 2480: from per_assignments_f ass

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
2482: and ass.person_id = P_PERSON_ID)
2483: );
2484: exception

Line 2495: from per_assignments_f ass

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

Line 2514: from per_assignments_f ass

2510:
2511: Delete pay_us_emp_fed_tax_rules_f peft
2512: Where peft.assignment_id in (
2513: select ass.assignment_id
2514: from per_assignments_f ass
2515: where ass.person_id = p_person_id );
2516: exception
2517: when no_data_found then
2518: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON',3802);

Line 2528: from per_assignments_f ass

2524:
2525: Delete pay_us_emp_state_tax_rules_f pest
2526: Where pest.assignment_id in (
2527: select ass.assignment_id
2528: from per_assignments_f ass
2529: where ass.person_id = p_person_id );
2530: exception
2531: when no_data_found then
2532: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON',3803);

Line 2542: from per_assignments_f ass

2538:
2539: Delete pay_us_emp_county_tax_rules_f pect
2540: Where pect.assignment_id in (
2541: select ass.assignment_id
2542: from per_assignments_f ass
2543: where ass.person_id = p_person_id );
2544: exception
2545: when no_data_found then
2546: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON',3804);

Line 2556: from per_assignments_f ass

2552:
2553: Delete pay_us_emp_city_tax_rules_f pecit
2554: Where pecit.assignment_id in (
2555: select ass.assignment_id
2556: from per_assignments_f ass
2557: where ass.person_id = p_person_id );
2558: exception
2559: when no_data_found then
2560: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON',3805);

Line 2868: from per_assignments_f ass

2864: --
2865: begin
2866: select ass.assignment_id
2867: into v_assignment_id
2868: from per_assignments_f ass
2869: where ass.person_id = P_PERSON_ID
2870: FOR UPDATE;
2871: exception
2872: when NO_DATA_FOUND then null;

Line 2962: delete from per_assignments_f ass

2958: --
2959: -- No exception, should succeed.
2960: --
2961: begin
2962: delete from per_assignments_f ass
2963: where ass.assignment_id = V_ASSIGNMENT_ID;
2964: end;
2965: --
2966: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 13);

Line 3077: from per_assignments_f ass

3073: --
3074: begin
3075: select ass.assignment_id
3076: into v_assignment_id
3077: from per_assignments_f ass
3078: where ass.person_id = P_PERSON_ID
3079: FOR UPDATE;
3080: end;
3081: --

Line 3104: delete from per_assignments_f ass

3100: --
3101: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 7);
3102: --
3103: begin
3104: delete from per_assignments_f ass
3105: where ass.assignment_id = V_ASSIGNMENT_ID;
3106: end;
3107: --
3108: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 8);