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_INTERNAL dependencies on PER_ASSIGNMENTS_F

Line 133: from per_assignments_f ass,

129: into l_delete_permitted
130: from sys.dual
131: where not exists
132: (select null
133: from per_assignments_f ass,
134: hr_assignment_set_amendments asa
135: where asa.assignment_id = ass.assignment_id
136: and ass.person_id = P_PERSON_ID
137: and asa.include_or_exclude = 'I'

Line 176: ,per_assignments_f ass

172: from sys.dual
173: where not exists
174: (select null
175: from pay_assignment_actions paa
176: ,per_assignments_f ass
177: ,pay_payroll_actions ppa
178: where paa.assignment_id = ass.assignment_id
179: and ass.person_id = P_PERSON_ID
180: and ppa.payroll_action_id = paa.payroll_action_id

Line 227: per_assignments_f a,

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

Line 285: from per_assignments_f a

281: into l_delete_permitted
282: from sys.dual
283: where not exists
284: (select null
285: from per_assignments_f a
286: ,per_contact_relationships c
287: ,per_cobra_cov_enrollments e
288: where a.person_id = P_PERSON_ID
289: and a.assignment_id = e.assignment_id

Line 874: from per_assignments_f a

870: select null
871: from per_letter_request_lines r
872: where exists (
873: select null
874: from per_assignments_f a
875: where a.person_id = P_PERSON_ID
876: and a.effective_start_date >= p_effective_date
877: and a.assignment_id = r.assignment_id));
878: --

Line 957: from per_assignments_f a

953: into l_delete_permitted
954: from sys.dual
955: where 1 >= (
956: select count(*)
957: from per_assignments_f a
958: where a.person_id = P_PERSON_ID
959: and a.effective_start_date >= p_effective_date);
960: --
961: exception

Line 978: from per_assignments_f a

974: into l_delete_permitted
975: from sys.dual
976: where not exists (
977: select null
978: from per_assignments_f a
979: where a.recruiter_id = P_PERSON_ID
980: or a.supervisor_id = P_PERSON_ID);
981: --
982: exception

Line 1185: per_assignments_f a,

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

Line 1213: per_assignments_f a

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

Line 1238: from per_assignments_f a

1234: select null
1235: from per_assignment_extra_info i
1236: where exists (
1237: select null
1238: from per_assignments_f a
1239: where a.person_id = P_PERSON_ID
1240: and a.assignment_id = i.assignment_id));
1241: --
1242: exception

Line 1262: from per_assignments_f a

1258: select null
1259: from per_secondary_ass_statuses s
1260: where exists (
1261: select null
1262: from per_assignments_f a
1263: where a.person_id = P_PERSON_ID
1264: and a.assignment_id = s.assignment_id));
1265: --
1266: exception

Line 1286: from per_assignments_f a

1282: select null
1283: from per_events e
1284: where exists (
1285: select null
1286: from per_assignments_f a
1287: where a.person_id = P_PERSON_ID
1288: and a.assignment_id = e.assignment_id));
1289: --
1290: exception

Line 1310: from per_assignments_f a

1306: select null
1307: from per_spinal_point_placements_f p
1308: where exists (
1309: select null
1310: from per_assignments_f a
1311: where a.person_id = P_PERSON_ID
1312: and a.assignment_id = p.assignment_id));
1313: --
1314: exception

Line 1334: from per_assignments_f a

1330: select null
1331: from per_quickpaint_result_text t
1332: where exists (
1333: select null
1334: from per_assignments_f a
1335: where a.person_id = P_PERSON_ID
1336: and a.assignment_id = t.assignment_id));
1337: --
1338: exception

Line 1358: from per_assignments_f a

1354: select null
1355: from per_cobra_cov_enrollments c
1356: where exists (
1357: select null
1358: from per_assignments_f a
1359: where a.person_id = P_PERSON_ID
1360: and a.assignment_id = c.assignment_id));
1361: --
1362: exception

Line 1549: from per_assignments_f ass

1545: begin
1546: --
1547: select ass.assignment_id
1548: into l_assignment_id
1549: from per_assignments_f ass
1550: where ass.person_id = P_PERSON_ID
1551: FOR UPDATE;
1552: exception
1553: when NO_DATA_FOUND then null;

Line 1661: delete from per_assignments_f ass

1657: --
1658: -- No exception, should succeed.
1659: --
1660: begin
1661: delete from per_assignments_f ass
1662: where ass.assignment_id = l_assignment_id;
1663: end;
1664: --
1665: if g_debug then

Line 1840: from per_assignments_f ass

1836: --
1837: begin
1838: select ass.assignment_id
1839: into l_assignment_id
1840: from per_assignments_f ass
1841: where ass.person_id = P_PERSON_ID
1842: FOR UPDATE;
1843: end;
1844: --

Line 1873: delete from per_assignments_f ass

1869: hr_utility.set_location(l_proc, 60);
1870: end if;
1871: --
1872: begin
1873: delete from per_assignments_f ass
1874: where ass.assignment_id = l_assignment_id;
1875: end;
1876: --
1877: if g_debug then

Line 1990: FROM per_assignments_f

1986: FOR UPDATE;
1987: --
1988: CURSOR csr_lock_assignment_rows IS
1989: SELECT assignment_id
1990: FROM per_assignments_f
1991: WHERE person_id = P_PERSON_ID
1992: FOR UPDATE;
1993: --
1994: CURSOR csr_delete_components IS

Line 1997: per_assignments_f pa

1993: --
1994: CURSOR csr_delete_components IS
1995: SELECT pp.pay_proposal_id
1996: FROM per_pay_proposals pp,
1997: per_assignments_f pa
1998: WHERE pa.person_id = P_PERSON_ID
1999: AND pa.assignment_id = pp.assignment_id
2000: FOR UPDATE;
2001: --

Line 2032: FROM per_assignments_f

2028: ORDER BY person_type_usage_id;
2029: --
2030: CURSOR csr_asg IS
2031: SELECT distinct assignment_id
2032: FROM per_assignments_f
2033: WHERE person_id = p_person_id;
2034: --
2035: CURSOR attached_docs_cursor IS
2036: SELECT attached_document_id

Line 2221: -- per_assignments_f.

2217: hr_utility.set_location(l_proc, 150);
2218: end if;
2219: --
2220: -- Delete of per_periods_of_service at end after delete of
2221: -- per_assignments_f.
2222: --
2223: begin
2224: --
2225: update per_periods_of_service p

Line 2504: update per_assignments_f ass

2500: end if;
2501: --
2502: begin
2503: --
2504: update per_assignments_f ass
2505: set ass.person_referred_by_id = null
2506: where ass.person_referred_by_id = P_PERSON_ID;
2507: --
2508: exception

Line 2521: update per_assignments_f a

2517: end if;
2518: --
2519: begin
2520: --
2521: update per_assignments_f a
2522: set a.recruiter_id = null
2523: where a.recruiter_id = P_PERSON_ID;
2524: --
2525: exception

Line 2538: update per_assignments_f a

2534: end if;
2535: --
2536: begin
2537: --
2538: update per_assignments_f a
2539: set a.supervisor_id = null
2540: where a.supervisor_id = P_PERSON_ID;
2541: --
2542: exception

Line 2584: from per_assignments_f ass

2580: --
2581: delete from per_pay_proposals p
2582: where exists (
2583: select null
2584: from per_assignments_f ass
2585: where ass.assignment_id = p.assignment_id
2586: and ass.person_id = P_PERSON_ID);
2587: --
2588: exception

Line 2604: from per_assignments_f ass

2600: --
2601: delete from pay_personal_payment_methods_f m
2602: where m.assignment_id in
2603: (select ass.assignment_id
2604: from per_assignments_f ass
2605: where ass.person_id = P_PERSON_ID);
2606: --
2607: exception
2608: when NO_DATA_FOUND then

Line 2623: from per_assignments_f ass

2619: --
2620: delete from per_assignment_budget_values_f a
2621: where a.assignment_id in
2622: (select ass.assignment_id
2623: from per_assignments_f ass
2624: where ass.person_id = P_PERSON_ID);
2625: --
2626: exception
2627: when NO_DATA_FOUND then

Line 2642: from per_assignments_f ass

2638: --
2639: delete from per_assignment_extra_info a
2640: where a.assignment_id in
2641: (select ass.assignment_id
2642: from per_assignments_f ass
2643: where ass.person_id = P_PERSON_ID);
2644: --
2645: exception
2646: when NO_DATA_FOUND then

Line 2661: from per_assignments_f ass

2657: --
2658: delete from per_secondary_ass_statuses a
2659: where a.assignment_id in
2660: (select ass.assignment_id
2661: from per_assignments_f ass
2662: where ass.person_id = P_PERSON_ID);
2663: --
2664: exception
2665: when NO_DATA_FOUND then

Line 2687: from per_assignments_f ass

2683: (select c.cobra_coverage_enrollment_id
2684: from per_cobra_cov_enrollments c
2685: where exists
2686: (select null
2687: from per_assignments_f ass
2688: where ass.assignment_id = c.assignment_id
2689: and ass.person_id = P_PERSON_ID)
2690: );
2691: --

Line 2714: from per_assignments_f ass

2710: where r.contact_person_id = P_PERSON_ID
2711: and c.contact_relationship_id = r.contact_relationship_id
2712: and exists
2713: (select null
2714: from per_assignments_f ass
2715: where ass.assignment_id = c.assignment_id
2716: and ass.person_id = r.person_id)
2717: );
2718: --

Line 2738: from per_assignments_f ass

2734: (select c.cobra_coverage_enrollment_id
2735: from per_cobra_cov_enrollments c
2736: where exists
2737: (select null
2738: from per_assignments_f ass
2739: where ass.assignment_id = c.assignment_id
2740: and ass.person_id = P_PERSON_ID)
2741: );
2742: --

Line 2765: from per_assignments_f ass

2761: where r.contact_person_id = P_PERSON_ID
2762: and c.contact_relationship_id = r.contact_relationship_id
2763: and exists
2764: (select null
2765: from per_assignments_f ass
2766: where ass.assignment_id = c.assignment_id
2767: and ass.person_id = r.person_id)
2768: );
2769: --

Line 2789: from per_assignments_f ass

2785: (select c.cobra_coverage_enrollment_id
2786: from per_cobra_cov_enrollments c
2787: where exists
2788: (select null
2789: from per_assignments_f ass
2790: where ass.assignment_id = c.assignment_id
2791: and ass.person_id = P_PERSON_ID)
2792: );
2793: --

Line 2816: from per_assignments_f ass

2812: where r.contact_person_id = P_PERSON_ID
2813: and c.contact_relationship_id = r.contact_relationship_id
2814: and exists
2815: (select null
2816: from per_assignments_f ass
2817: where ass.assignment_id = c.assignment_id
2818: and ass.person_id = r.person_id)
2819: );
2820: --

Line 2837: from per_assignments_f ass

2833: --
2834: delete from per_cobra_cov_enrollments c
2835: where c.assignment_id in
2836: (select ass.assignment_id
2837: from per_assignments_f ass
2838: where ass.person_id = P_PERSON_ID);
2839: --
2840: exception
2841: when NO_DATA_FOUND then

Line 2861: from per_assignments_f ass

2857: where r.contact_person_id = P_PERSON_ID
2858: and c.contact_relationship_id = r.contact_relationship_id
2859: and exists
2860: (select null
2861: from per_assignments_f ass
2862: where ass.assignment_id = c.assignment_id
2863: and ass.person_id = r.person_id)
2864: );
2865: --

Line 3048: from per_assignments_f ass

3044: (select e.event_id
3045: from per_events e
3046: where exists (
3047: select null
3048: from per_assignments_f ass
3049: where ass.assignment_id = e.assignment_id
3050: and ass.person_id = P_PERSON_ID)
3051: );*/
3052: exception

Line 3074: from per_assignments_f ass

3070:
3071: /* delete from per_events e
3072: where e.assignment_id in (
3073: select ass.assignment_id
3074: from per_assignments_f ass
3075: where ass.person_id = P_PERSON_ID);*/
3076: exception
3077: when NO_DATA_FOUND then
3078: if g_debug then

Line 3125: from per_assignments_f ass

3121: --
3122: delete from per_quickpaint_result_text q
3123: where q.assignment_id in
3124: (select ass.assignment_id
3125: from per_assignments_f ass
3126: where ass.person_id = P_PERSON_ID);
3127: --
3128: exception
3129: when NO_DATA_FOUND then

Line 3147: from per_assignments_f ass

3143: --
3144: delete from hr_assignment_set_amendments h
3145: where h.assignment_id in
3146: (select ass.assignment_id
3147: from per_assignments_f ass
3148: where ass.person_id = P_PERSON_ID);
3149: --
3150: exception
3151: when NO_DATA_FOUND then

Line 3166: from per_assignments_f ass

3162: --
3163: delete from pay_cost_allocations_f a
3164: where a.assignment_id in
3165: (select ass.assignment_id
3166: from per_assignments_f ass
3167: where ass.person_id = P_PERSON_ID);
3168: --
3169: exception
3170: when NO_DATA_FOUND then

Line 3185: from per_assignments_f ass

3181: --
3182: delete from per_spinal_point_placements_f p
3183: where p.assignment_id in
3184: (select ass.assignment_id
3185: from per_assignments_f ass
3186: where ass.person_id = P_PERSON_ID);
3187: --
3188: exception
3189: when NO_DATA_FOUND then

Line 3207: from per_assignments_f ass

3203: --
3204: delete from pay_assignment_actions a
3205: where a.assignment_id in
3206: (select ass.assignment_id
3207: from per_assignments_f ass
3208: where ass.person_id = P_PERSON_ID);
3209: --
3210: exception
3211: when NO_DATA_FOUND then

Line 3226: from per_assignments_f ass

3222: --
3223: delete from pay_assignment_latest_balances b
3224: where b.assignment_id in
3225: (select ass.assignment_id
3226: from per_assignments_f ass
3227: where ass.person_id = P_PERSON_ID);
3228: --
3229: exception
3230: when NO_DATA_FOUND then

Line 3252: from per_assignments_f ass

3248: /*delete from pay_assignment_link_usages_f u
3249: where
3250: u.assignment_id in (
3251: select ass.assignment_id
3252: from per_assignments_f ass
3253: where ass.person_id = P_PERSON_ID); */
3254: exception
3255: when NO_DATA_FOUND then
3256: if g_debug then

Line 3273: from per_assignments_f ass

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
3275: and ass.person_id = P_PERSON_ID)
3276: );
3277: --

Line 3298: from per_assignments_f ass

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
3300: and ass.person_id = P_PERSON_ID)
3301: );
3302: --

Line 3319: from per_assignments_f ass

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);
3321: --
3322: exception
3323: when NO_DATA_FOUND then

Line 3343: from per_assignments_f ass

3339: --
3340: Delete pay_us_emp_fed_tax_rules_f peft
3341: Where peft.assignment_id in
3342: (select ass.assignment_id
3343: from per_assignments_f ass
3344: where ass.person_id = p_person_id );
3345: --
3346: exception
3347: when no_data_found then

Line 3362: from per_assignments_f ass

3358: --
3359: Delete pay_us_emp_state_tax_rules_f pest
3360: Where pest.assignment_id in
3361: (select ass.assignment_id
3362: from per_assignments_f ass
3363: where ass.person_id = p_person_id );
3364: --
3365: exception
3366: when no_data_found then

Line 3381: from per_assignments_f ass

3377: --
3378: Delete pay_us_emp_county_tax_rules_f pect
3379: Where pect.assignment_id in
3380: (select ass.assignment_id
3381: from per_assignments_f ass
3382: where ass.person_id = p_person_id );
3383: --
3384: exception
3385: when no_data_found then

Line 3400: from per_assignments_f ass

3396: --
3397: Delete pay_us_emp_city_tax_rules_f pecit
3398: Where pecit.assignment_id in
3399: (select ass.assignment_id
3400: from per_assignments_f ass
3401: where ass.person_id = p_person_id );
3402: --
3403: exception
3404: when no_data_found then