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 845: from per_assignments_f a

841: select null
842: from per_letter_request_lines r
843: where exists (
844: select null
845: from per_assignments_f a
846: where a.person_id = P_PERSON_ID
847: and a.effective_start_date >= p_effective_date
848: and a.assignment_id = r.assignment_id));
849: --

Line 928: from per_assignments_f a

924: into l_delete_permitted
925: from sys.dual
926: where 1 >= (
927: select count(*)
928: from per_assignments_f a
929: where a.person_id = P_PERSON_ID
930: and a.effective_start_date >= p_effective_date);
931: --
932: exception

Line 949: from per_assignments_f a

945: into l_delete_permitted
946: from sys.dual
947: where not exists (
948: select null
949: from per_assignments_f a
950: where a.recruiter_id = P_PERSON_ID
951: or a.supervisor_id = P_PERSON_ID);
952: --
953: exception

Line 1156: per_assignments_f a,

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

Line 1184: per_assignments_f a

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

Line 1209: from per_assignments_f a

1205: select null
1206: from per_assignment_extra_info i
1207: where exists (
1208: select null
1209: from per_assignments_f a
1210: where a.person_id = P_PERSON_ID
1211: and a.assignment_id = i.assignment_id));
1212: --
1213: exception

Line 1233: from per_assignments_f a

1229: select null
1230: from per_secondary_ass_statuses s
1231: where exists (
1232: select null
1233: from per_assignments_f a
1234: where a.person_id = P_PERSON_ID
1235: and a.assignment_id = s.assignment_id));
1236: --
1237: exception

Line 1257: from per_assignments_f a

1253: select null
1254: from per_events e
1255: where exists (
1256: select null
1257: from per_assignments_f a
1258: where a.person_id = P_PERSON_ID
1259: and a.assignment_id = e.assignment_id));
1260: --
1261: exception

Line 1281: from per_assignments_f a

1277: select null
1278: from per_spinal_point_placements_f p
1279: where exists (
1280: select null
1281: from per_assignments_f a
1282: where a.person_id = P_PERSON_ID
1283: and a.assignment_id = p.assignment_id));
1284: --
1285: exception

Line 1305: from per_assignments_f a

1301: select null
1302: from per_quickpaint_result_text t
1303: where exists (
1304: select null
1305: from per_assignments_f a
1306: where a.person_id = P_PERSON_ID
1307: and a.assignment_id = t.assignment_id));
1308: --
1309: exception

Line 1329: from per_assignments_f a

1325: select null
1326: from per_cobra_cov_enrollments c
1327: where exists (
1328: select null
1329: from per_assignments_f a
1330: where a.person_id = P_PERSON_ID
1331: and a.assignment_id = c.assignment_id));
1332: --
1333: exception

Line 1519: from per_assignments_f ass

1515: begin
1516: --
1517: select ass.assignment_id
1518: into l_assignment_id
1519: from per_assignments_f ass
1520: where ass.person_id = P_PERSON_ID
1521: FOR UPDATE;
1522: exception
1523: when NO_DATA_FOUND then null;

Line 1631: delete from per_assignments_f ass

1627: --
1628: -- No exception, should succeed.
1629: --
1630: begin
1631: delete from per_assignments_f ass
1632: where ass.assignment_id = l_assignment_id;
1633: end;
1634: --
1635: if g_debug then

Line 1809: from per_assignments_f ass

1805: --
1806: begin
1807: select ass.assignment_id
1808: into l_assignment_id
1809: from per_assignments_f ass
1810: where ass.person_id = P_PERSON_ID
1811: FOR UPDATE;
1812: end;
1813: --

Line 1842: delete from per_assignments_f ass

1838: hr_utility.set_location(l_proc, 60);
1839: end if;
1840: --
1841: begin
1842: delete from per_assignments_f ass
1843: where ass.assignment_id = l_assignment_id;
1844: end;
1845: --
1846: if g_debug then

Line 1959: FROM per_assignments_f

1955: FOR UPDATE;
1956: --
1957: CURSOR csr_lock_assignment_rows IS
1958: SELECT assignment_id
1959: FROM per_assignments_f
1960: WHERE person_id = P_PERSON_ID
1961: FOR UPDATE;
1962: --
1963: CURSOR csr_delete_components IS

Line 1966: per_assignments_f pa

1962: --
1963: CURSOR csr_delete_components IS
1964: SELECT pp.pay_proposal_id
1965: FROM per_pay_proposals pp,
1966: per_assignments_f pa
1967: WHERE pa.person_id = P_PERSON_ID
1968: AND pa.assignment_id = pp.assignment_id
1969: FOR UPDATE;
1970: --

Line 2001: FROM per_assignments_f

1997: ORDER BY person_type_usage_id;
1998: --
1999: CURSOR csr_asg IS
2000: SELECT distinct assignment_id
2001: FROM per_assignments_f
2002: WHERE person_id = p_person_id;
2003: --
2004: CURSOR attached_docs_cursor IS
2005: SELECT attached_document_id

Line 2189: -- per_assignments_f.

2185: hr_utility.set_location(l_proc, 150);
2186: end if;
2187: --
2188: -- Delete of per_periods_of_service at end after delete of
2189: -- per_assignments_f.
2190: --
2191: begin
2192: --
2193: update per_periods_of_service p

Line 2451: update per_assignments_f ass

2447: end if;
2448: --
2449: begin
2450: --
2451: update per_assignments_f ass
2452: set ass.person_referred_by_id = null
2453: where ass.person_referred_by_id = P_PERSON_ID;
2454: --
2455: exception

Line 2468: update per_assignments_f a

2464: end if;
2465: --
2466: begin
2467: --
2468: update per_assignments_f a
2469: set a.recruiter_id = null
2470: where a.recruiter_id = P_PERSON_ID;
2471: --
2472: exception

Line 2485: update per_assignments_f a

2481: end if;
2482: --
2483: begin
2484: --
2485: update per_assignments_f a
2486: set a.supervisor_id = null
2487: where a.supervisor_id = P_PERSON_ID;
2488: --
2489: exception

Line 2531: from per_assignments_f ass

2527: --
2528: delete from per_pay_proposals p
2529: where exists (
2530: select null
2531: from per_assignments_f ass
2532: where ass.assignment_id = p.assignment_id
2533: and ass.person_id = P_PERSON_ID);
2534: --
2535: exception

Line 2551: from per_assignments_f ass

2547: --
2548: delete from pay_personal_payment_methods_f m
2549: where m.assignment_id in
2550: (select ass.assignment_id
2551: from per_assignments_f ass
2552: where ass.person_id = P_PERSON_ID);
2553: --
2554: exception
2555: when NO_DATA_FOUND then

Line 2570: from per_assignments_f ass

2566: --
2567: delete from per_assignment_budget_values_f a
2568: where a.assignment_id in
2569: (select ass.assignment_id
2570: from per_assignments_f ass
2571: where ass.person_id = P_PERSON_ID);
2572: --
2573: exception
2574: when NO_DATA_FOUND then

Line 2589: from per_assignments_f ass

2585: --
2586: delete from per_assignment_extra_info a
2587: where a.assignment_id in
2588: (select ass.assignment_id
2589: from per_assignments_f ass
2590: where ass.person_id = P_PERSON_ID);
2591: --
2592: exception
2593: when NO_DATA_FOUND then

Line 2608: from per_assignments_f ass

2604: --
2605: delete from per_secondary_ass_statuses a
2606: where a.assignment_id in
2607: (select ass.assignment_id
2608: from per_assignments_f ass
2609: where ass.person_id = P_PERSON_ID);
2610: --
2611: exception
2612: when NO_DATA_FOUND then

Line 2634: from per_assignments_f ass

2630: (select c.cobra_coverage_enrollment_id
2631: from per_cobra_cov_enrollments c
2632: where exists
2633: (select null
2634: from per_assignments_f ass
2635: where ass.assignment_id = c.assignment_id
2636: and ass.person_id = P_PERSON_ID)
2637: );
2638: --

Line 2661: from per_assignments_f ass

2657: where r.contact_person_id = P_PERSON_ID
2658: and c.contact_relationship_id = r.contact_relationship_id
2659: and exists
2660: (select null
2661: from per_assignments_f ass
2662: where ass.assignment_id = c.assignment_id
2663: and ass.person_id = r.person_id)
2664: );
2665: --

Line 2685: from per_assignments_f ass

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

Line 2712: from per_assignments_f ass

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

Line 2736: from per_assignments_f ass

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

Line 2763: from per_assignments_f ass

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

Line 2784: from per_assignments_f ass

2780: --
2781: delete from per_cobra_cov_enrollments c
2782: where c.assignment_id in
2783: (select ass.assignment_id
2784: from per_assignments_f ass
2785: where ass.person_id = P_PERSON_ID);
2786: --
2787: exception
2788: when NO_DATA_FOUND then

Line 2808: from per_assignments_f ass

2804: where r.contact_person_id = P_PERSON_ID
2805: and c.contact_relationship_id = r.contact_relationship_id
2806: and exists
2807: (select null
2808: from per_assignments_f ass
2809: where ass.assignment_id = c.assignment_id
2810: and ass.person_id = r.person_id)
2811: );
2812: --

Line 2995: from per_assignments_f ass

2991: (select e.event_id
2992: from per_events e
2993: where exists (
2994: select null
2995: from per_assignments_f ass
2996: where ass.assignment_id = e.assignment_id
2997: and ass.person_id = P_PERSON_ID)
2998: );*/
2999: exception

Line 3021: from per_assignments_f ass

3017:
3018: /* delete from per_events e
3019: where e.assignment_id in (
3020: select ass.assignment_id
3021: from per_assignments_f ass
3022: where ass.person_id = P_PERSON_ID);*/
3023: exception
3024: when NO_DATA_FOUND then
3025: if g_debug then

Line 3072: from per_assignments_f ass

3068: --
3069: delete from per_quickpaint_result_text q
3070: where q.assignment_id in
3071: (select ass.assignment_id
3072: from per_assignments_f ass
3073: where ass.person_id = P_PERSON_ID);
3074: --
3075: exception
3076: when NO_DATA_FOUND then

Line 3094: from per_assignments_f ass

3090: --
3091: delete from hr_assignment_set_amendments h
3092: where h.assignment_id in
3093: (select ass.assignment_id
3094: from per_assignments_f ass
3095: where ass.person_id = P_PERSON_ID);
3096: --
3097: exception
3098: when NO_DATA_FOUND then

Line 3113: from per_assignments_f ass

3109: --
3110: delete from pay_cost_allocations_f a
3111: where a.assignment_id in
3112: (select ass.assignment_id
3113: from per_assignments_f ass
3114: where ass.person_id = P_PERSON_ID);
3115: --
3116: exception
3117: when NO_DATA_FOUND then

Line 3132: from per_assignments_f ass

3128: --
3129: delete from per_spinal_point_placements_f p
3130: where p.assignment_id in
3131: (select ass.assignment_id
3132: from per_assignments_f ass
3133: where ass.person_id = P_PERSON_ID);
3134: --
3135: exception
3136: when NO_DATA_FOUND then

Line 3154: from per_assignments_f ass

3150: --
3151: delete from pay_assignment_actions a
3152: where a.assignment_id in
3153: (select ass.assignment_id
3154: from per_assignments_f ass
3155: where ass.person_id = P_PERSON_ID);
3156: --
3157: exception
3158: when NO_DATA_FOUND then

Line 3173: from per_assignments_f ass

3169: --
3170: delete from pay_assignment_latest_balances b
3171: where b.assignment_id in
3172: (select ass.assignment_id
3173: from per_assignments_f ass
3174: where ass.person_id = P_PERSON_ID);
3175: --
3176: exception
3177: when NO_DATA_FOUND then

Line 3199: from per_assignments_f ass

3195: /*delete from pay_assignment_link_usages_f u
3196: where
3197: u.assignment_id in (
3198: select ass.assignment_id
3199: from per_assignments_f ass
3200: where ass.person_id = P_PERSON_ID); */
3201: exception
3202: when NO_DATA_FOUND then
3203: if g_debug then

Line 3220: from per_assignments_f ass

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
3222: and ass.person_id = P_PERSON_ID)
3223: );
3224: --

Line 3245: from per_assignments_f ass

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
3247: and ass.person_id = P_PERSON_ID)
3248: );
3249: --

Line 3266: from per_assignments_f ass

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);
3268: --
3269: exception
3270: when NO_DATA_FOUND then

Line 3290: from per_assignments_f ass

3286: --
3287: Delete pay_us_emp_fed_tax_rules_f peft
3288: Where peft.assignment_id in
3289: (select ass.assignment_id
3290: from per_assignments_f ass
3291: where ass.person_id = p_person_id );
3292: --
3293: exception
3294: when no_data_found then

Line 3309: from per_assignments_f ass

3305: --
3306: Delete pay_us_emp_state_tax_rules_f pest
3307: Where pest.assignment_id in
3308: (select ass.assignment_id
3309: from per_assignments_f ass
3310: where ass.person_id = p_person_id );
3311: --
3312: exception
3313: when no_data_found then

Line 3328: from per_assignments_f ass

3324: --
3325: Delete pay_us_emp_county_tax_rules_f pect
3326: Where pect.assignment_id in
3327: (select ass.assignment_id
3328: from per_assignments_f ass
3329: where ass.person_id = p_person_id );
3330: --
3331: exception
3332: when no_data_found then

Line 3347: from per_assignments_f ass

3343: --
3344: Delete pay_us_emp_city_tax_rules_f pecit
3345: Where pecit.assignment_id in
3346: (select ass.assignment_id
3347: from per_assignments_f ass
3348: where ass.person_id = p_person_id );
3349: --
3350: exception
3351: when no_data_found then