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.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_ASSIGNMENTS_F

Line 194: , per_assignments_f paf

190: --
191: cursor comments is
192: select h.rowid
193: from hr_comments h
194: , per_assignments_f paf
195: where h.comment_id = paf.comment_id
196: and paf.business_group_id + 0 = p_business_group_id
197: and paf.person_id = p_person_id
198: and paf.effective_start_date >= p_effective_date

Line 224: , per_assignments_f paf

220: --
221: cursor budget_values is
222: select pab.rowid
223: from per_assignment_budget_values_f pab
224: , per_assignments_f paf
225: where pab.business_group_id + 0 = paf.business_group_id + 0
226: and paf.business_group_id + 0 = p_business_group_id
227: and pab.assignment_id = paf.assignment_id
228: and paf.person_id = p_person_id

Line 237: from per_assignments_f p

233: -- recruiter cursor
234: --
235: cursor recruiter is
236: select rowid
237: from per_assignments_f p
238: where p.recruiter_id = p_person_id
239: and (p.business_group_id = p_business_group_id OR
240: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
241: for update of assignment_id;

Line 280: from per_assignments_f p

276: for update of person_id;
277: --
278: cursor supervisor is
279: select rowid
280: from per_assignments_f p
281: where (p.business_group_id = p_business_group_id OR
282: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
283: and p.supervisor_id = p_person_id
284: for update of assignment_id;

Line 296: from per_assignments_f paf

292: --CWK assignments cursor
293: --
294: cursor cwk_ass is
295: select paf.rowid
296: from per_assignments_f paf
297: where paf.business_group_id + 0 = p_business_group_id
298: and paf.person_id = p_person_id
299: and paf.assignment_type = 'C'
300: for update of paf.assignment_id;

Line 314: from per_assignments_f paf

310: cursor csr_assignment_rate_values is
311: select pgr.rowid
312: from pay_grade_rules_f pgr
313: where exists (select 'x'
314: from per_assignments_f paf
315: where pgr.grade_or_spinal_point_id = paf.assignment_id
316: and paf.business_group_id + 0 = p_business_group_id
317: and paf.person_id = p_person_id)
318: for update of pgr.grade_or_spinal_point_id;

Line 325: from per_assignments_f paf

321: select spp.rowid
322: from per_spinal_point_placements_f spp
323: where spp.business_group_id = p_business_group_id and
324: exists (select 'x'
325: from per_assignments_f paf
326: where spp.assignment_id = paf.assignment_id
327: and paf.business_group_id + 0 = p_business_group_id
328: and paf.person_id = p_person_id)
329: for update of spp.assignment_id;

Line 335: from per_assignments_f paf

331: cursor csr_cost_allocations is
332: select pca.rowid
333: from pay_cost_allocations_f pca
334: where exists (select 'x'
335: from per_assignments_f paf
336: where pca.assignment_id = paf.assignment_id
337: and paf.business_group_id + 0 = p_business_group_id
338: and paf.person_id = p_person_id)
339: for update of pca.assignment_id;

Line 492: from per_assignments_f p

488: -- supervisor cursor.
489: --
490: cursor supervisor is
491: select rowid
492: from per_assignments_f p
493: where (p.business_group_id = p_business_group_id OR
494: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
495: and p.supervisor_id = p_person_id
496: for update of assignment_id;

Line 502: from per_assignments_f p

498: -- recruiter cursor
499: --
500: cursor recruiter is
501: select rowid
502: from per_assignments_f p
503: where p.recruiter_id = p_person_id
504: and (p.business_group_id = p_business_group_id OR
505: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
506: for update of assignment_id;

Line 577: , per_assignments_f paf

573: --
574: cursor budget_values is
575: select pab.rowid
576: from per_assignment_budget_values_f pab
577: , per_assignments_f paf
578: where pab.business_group_id + 0 = paf.business_group_id + 0
579: and paf.business_group_id + 0 = p_business_group_id
580: and pab.assignment_id = paf.assignment_id
581: and paf.person_id = p_person_id

Line 591: , per_assignments_f paf

587: --
588: cursor letters is
589: select p.rowid
590: from per_letter_request_lines p
591: , per_assignments_f paf
592: where p.assignment_id = paf.assignment_id
593: and paf.business_group_id + 0 = p_business_group_id
594: and paf.person_id = p_person_id
595: and paf.application_id = p_primary_id

Line 604: , per_assignments_f paf

600: --
601: cursor comments is
602: select h.rowid
603: from hr_comments h
604: , per_assignments_f paf
605: where h.comment_id = paf.comment_id
606: and paf.business_group_id + 0 = p_business_group_id
607: and paf.person_id = p_person_id
608: and paf.application_id = p_primary_id

Line 616: from per_assignments_f paf

612: --appl assignments cursor
613: --
614: cursor appl_ass is
615: select paf.rowid
616: from per_assignments_f paf
617: where paf.business_group_id + 0 = p_business_group_id
618: and paf.person_id = p_person_id
619: and paf.assignment_type = 'A'
620: and paf.application_id = p_primary_id

Line 627: from per_assignments_f paf

623: --emp assignments cursor
624: --
625: cursor emp_ass is
626: select paf.rowid
627: from per_assignments_f paf
628: where paf.business_group_id + 0 = p_business_group_id
629: and paf.person_id = p_person_id
630: and paf.assignment_type = 'E'
631: and paf.application_id = p_primary_id

Line 841: from per_assignments_f p

837: -- Supervisor
838: --
839: cursor supervisor is
840: select rowid
841: from per_assignments_f p
842: where (p.business_group_id = p_business_group_id OR
843: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
844: and p.supervisor_id = p_person_id
845: --start changes for bug 9304366

Line 861: from per_assignments_f p

857: -- recruiter cursor
858: --
859: cursor recruiter is
860: select rowid
861: from per_assignments_f p
862: where p.recruiter_id = p_person_id
863: and (p.business_group_id = p_business_group_id OR
864: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
865: --start changes for bug 9304366

Line 957: per_assignments_f asg

953: cursor csr_payactions is
954: SELECT null
955: FROM pay_payroll_actions pac,
956: pay_assignment_actions act,
957: per_assignments_f asg
958: WHERE asg.person_id = p_person_id
959: --
960: -- 115.51 (START)
961: --

Line 986: per_assignments_f asg

982: cursor csr_payactions_us is
983: SELECT null
984: FROM pay_payroll_actions pac,
985: pay_assignment_actions act,
986: per_assignments_f asg
987: WHERE asg.person_id = p_person_id
988: AND asg.period_of_service_id = p_primary_id
989: AND act.assignment_id = asg.assignment_id
990: AND pac.payroll_action_id = act.payroll_action_id

Line 1608: per_assignments_f asg

1604:
1605: SELECT null
1606: FROM pay_payroll_actions pac,
1607: pay_assignment_actions act,
1608: per_assignments_f asg
1609: WHERE asg.person_id = p_person_id
1610: AND asg.period_of_service_id = l_period_of_service_id
1611: AND act.assignment_id = asg.assignment_id
1612: AND pac.payroll_action_id = act.payroll_action_id

Line 2101: from per_assignments_f p

2097: -- supervisor cursor.
2098: --
2099: cursor supervisor1 is
2100: select rowid
2101: from per_assignments_f p
2102: where (p.business_group_id = p_business_group_id OR
2103: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2104: and p.supervisor_id = p_person_id
2105: --start changes for bug 9304366

Line 2121: from per_assignments_f p

2117: -- recruiter cursor
2118: --
2119: cursor recruiter1 is
2120: select rowid
2121: from per_assignments_f p
2122: where p.recruiter_id = p_person_id
2123: and (p.business_group_id = p_business_group_id OR
2124: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2125: --start changes for bug 9304366

Line 3141: from per_assignments_f

3137: -- determine the assignment_id for all the assignments of the application
3138: --
3139: cursor appl_asg is
3140: select distinct assignment_id
3141: from per_assignments_f
3142: where application_id = p_application_id;
3143: --
3144: -- events cursor -- This is only really finding applicant interviews
3145: -- since in all other cases pe.assignment_id is null

Line 3183: , per_assignments_f paf

3179: --
3180: cursor comments2(p_assignment_id NUMBER) is
3181: select h.comment_id
3182: from hr_comments h
3183: , per_assignments_f paf
3184: where h.comment_id = paf.comment_id
3185: and paf.assignment_id = p_assignment_id;
3186: --
3187: -- assignments cursor

Line 3191: from per_assignments_f paf

3187: -- assignments cursor
3188: --
3189: cursor assignments is
3190: select paf.rowid
3191: from per_assignments_f paf
3192: where paf.person_id = p_person_id
3193: and paf.application_id = p_application_id;
3194: --
3195: -- applications cursor

Line 3625: delete from per_assignments_f paf

3621: <>
3622: loop
3623: fetch assignments into l_rowid;
3624: exit when assignments%NOTFOUND;
3625: delete from per_assignments_f paf
3626: where paf.rowid = l_rowid;
3627: if sql%notfound then
3628: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3629: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');

Line 4002: FROM per_assignments_f paf

3998: -- Multi Assignment Check
3999: --
4000: CURSOR csr_multi_asg_check IS
4001: SELECT assignment_id
4002: FROM per_assignments_f paf
4003: WHERE (paf.business_group_id = p_business_group_id OR
4004: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4005: AND paf.person_id = p_person_id;
4006: --

Line 4021: FROM per_assignments_f p

4017: -- Supervisor
4018: --
4019: CURSOR csr_supervisor IS
4020: SELECT ROWID
4021: FROM per_assignments_f p
4022: WHERE (p.business_group_id = p_business_group_id OR
4023: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4024: AND p.supervisor_id = p_person_id
4025: --start changes for bug 13014331

Line 4042: FROM per_assignments_f p

4038: -- recruiter cursor
4039: --
4040: CURSOR csr_recruiter IS
4041: SELECT ROWID
4042: FROM per_assignments_f p
4043: WHERE p.recruiter_id = p_person_id
4044: AND (p.business_group_id = p_business_group_id OR
4045: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y');
4046: --

Line 4567: FROM per_assignments_f p

4563: -- supervisor cursor.
4564: --
4565: CURSOR csr_supervisor IS
4566: SELECT ROWID
4567: FROM per_assignments_f p
4568: WHERE (p.business_group_id = p_business_group_id OR
4569: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4570: AND p.supervisor_id = p_person_id
4571: --start changes for bug 13014331

Line 4588: FROM per_assignments_f p

4584: -- recruiter cursor
4585: --
4586: CURSOR csr_recruiter IS
4587: SELECT ROWID
4588: FROM per_assignments_f p
4589: WHERE p.recruiter_id = p_person_id
4590: AND (p.business_group_id = p_business_group_id OR
4591: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y');
4592: --

Line 4673: FROM per_assignments_f paf

4669: CURSOR csr_assignment_rate_values IS
4670: SELECT pgr.rowid
4671: FROM pay_grade_rules_f pgr
4672: WHERE EXISTS (SELECT 'X'
4673: FROM per_assignments_f paf
4674: WHERE pgr.grade_or_spinal_point_id = paf.assignment_id
4675: and paf.business_group_id + 0 = p_business_group_id
4676: AND paf.person_id = p_person_id);
4677: --