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 26: , per_assignments_f paf

22: --
23: cursor comments is
24: select h.rowid
25: from hr_comments h
26: , per_assignments_f paf
27: where h.comment_id = paf.comment_id
28: and paf.business_group_id + 0 = p_business_group_id
29: and paf.person_id = p_person_id
30: and paf.effective_start_date >= p_effective_date

Line 56: , per_assignments_f paf

52: --
53: cursor budget_values is
54: select pab.rowid
55: from per_assignment_budget_values_f pab
56: , per_assignments_f paf
57: where pab.business_group_id + 0 = paf.business_group_id + 0
58: and paf.business_group_id + 0 = p_business_group_id
59: and pab.assignment_id = paf.assignment_id
60: and paf.person_id = p_person_id

Line 69: from per_assignments_f p

65: -- recruiter cursor
66: --
67: cursor recruiter is
68: select rowid
69: from per_assignments_f p
70: where p.recruiter_id = p_person_id
71: and (p.business_group_id = p_business_group_id OR
72: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
73: for update of assignment_id;

Line 112: from per_assignments_f p

108: for update of person_id;
109: --
110: cursor supervisor is
111: select rowid
112: from per_assignments_f p
113: where (p.business_group_id = p_business_group_id OR
114: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
115: and p.supervisor_id = p_person_id
116: for update of assignment_id;

Line 128: from per_assignments_f paf

124: --CWK assignments cursor
125: --
126: cursor cwk_ass is
127: select paf.rowid
128: from per_assignments_f paf
129: where paf.business_group_id + 0 = p_business_group_id
130: and paf.person_id = p_person_id
131: and paf.assignment_type = 'C'
132: for update of paf.assignment_id;

Line 146: from per_assignments_f paf

142: cursor csr_assignment_rate_values is
143: select pgr.rowid
144: from pay_grade_rules_f pgr
145: where exists (select 'x'
146: from per_assignments_f paf
147: where pgr.grade_or_spinal_point_id = paf.assignment_id
148: and paf.business_group_id + 0 = p_business_group_id
149: and paf.person_id = p_person_id)
150: for update of pgr.grade_or_spinal_point_id;

Line 157: from per_assignments_f paf

153: select spp.rowid
154: from per_spinal_point_placements_f spp
155: where spp.business_group_id = p_business_group_id and
156: exists (select 'x'
157: from per_assignments_f paf
158: where spp.assignment_id = paf.assignment_id
159: and paf.business_group_id + 0 = p_business_group_id
160: and paf.person_id = p_person_id)
161: for update of spp.assignment_id;

Line 167: from per_assignments_f paf

163: cursor csr_cost_allocations is
164: select pca.rowid
165: from pay_cost_allocations_f pca
166: where exists (select 'x'
167: from per_assignments_f paf
168: where pca.assignment_id = paf.assignment_id
169: and paf.business_group_id + 0 = p_business_group_id
170: and paf.person_id = p_person_id)
171: for update of pca.assignment_id;

Line 324: from per_assignments_f p

320: -- supervisor cursor.
321: --
322: cursor supervisor is
323: select rowid
324: from per_assignments_f p
325: where (p.business_group_id = p_business_group_id OR
326: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
327: and p.supervisor_id = p_person_id
328: for update of assignment_id;

Line 334: from per_assignments_f p

330: -- recruiter cursor
331: --
332: cursor recruiter is
333: select rowid
334: from per_assignments_f p
335: where p.recruiter_id = p_person_id
336: and (p.business_group_id = p_business_group_id OR
337: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
338: for update of assignment_id;

Line 409: , per_assignments_f paf

405: --
406: cursor budget_values is
407: select pab.rowid
408: from per_assignment_budget_values_f pab
409: , per_assignments_f paf
410: where pab.business_group_id + 0 = paf.business_group_id + 0
411: and paf.business_group_id + 0 = p_business_group_id
412: and pab.assignment_id = paf.assignment_id
413: and paf.person_id = p_person_id

Line 423: , per_assignments_f paf

419: --
420: cursor letters is
421: select p.rowid
422: from per_letter_request_lines p
423: , per_assignments_f paf
424: where p.assignment_id = paf.assignment_id
425: and paf.business_group_id + 0 = p_business_group_id
426: and paf.person_id = p_person_id
427: and paf.application_id = p_primary_id

Line 436: , per_assignments_f paf

432: --
433: cursor comments is
434: select h.rowid
435: from hr_comments h
436: , per_assignments_f paf
437: where h.comment_id = paf.comment_id
438: and paf.business_group_id + 0 = p_business_group_id
439: and paf.person_id = p_person_id
440: and paf.application_id = p_primary_id

Line 448: from per_assignments_f paf

444: --appl assignments cursor
445: --
446: cursor appl_ass is
447: select paf.rowid
448: from per_assignments_f paf
449: where paf.business_group_id + 0 = p_business_group_id
450: and paf.person_id = p_person_id
451: and paf.assignment_type = 'A'
452: and paf.application_id = p_primary_id

Line 459: from per_assignments_f paf

455: --emp assignments cursor
456: --
457: cursor emp_ass is
458: select paf.rowid
459: from per_assignments_f paf
460: where paf.business_group_id + 0 = p_business_group_id
461: and paf.person_id = p_person_id
462: and paf.assignment_type = 'E'
463: and paf.application_id = p_primary_id

Line 673: from per_assignments_f p

669: -- Supervisor
670: --
671: cursor supervisor is
672: select rowid
673: from per_assignments_f p
674: where (p.business_group_id = p_business_group_id OR
675: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
676: and p.supervisor_id = p_person_id;
677: --

Line 682: from per_assignments_f p

678: -- recruiter cursor
679: --
680: cursor recruiter is
681: select rowid
682: from per_assignments_f p
683: where p.recruiter_id = p_person_id
684: and (p.business_group_id = p_business_group_id OR
685: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y');
686: --

Line 773: per_assignments_f asg

769: cursor csr_payactions is
770: SELECT null
771: FROM pay_payroll_actions pac,
772: pay_assignment_actions act,
773: per_assignments_f asg
774: WHERE asg.person_id = p_person_id
775: --
776: -- 115.51 (START)
777: --

Line 1206: from per_assignments_f p

1202: -- supervisor cursor.
1203: --
1204: cursor supervisor1 is
1205: select rowid
1206: from per_assignments_f p
1207: where (p.business_group_id = p_business_group_id OR
1208: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1209: and p.supervisor_id = p_person_id;
1210: --

Line 1215: from per_assignments_f p

1211: -- recruiter cursor
1212: --
1213: cursor recruiter1 is
1214: select rowid
1215: from per_assignments_f p
1216: where p.recruiter_id = p_person_id
1217: and (p.business_group_id = p_business_group_id OR
1218: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y');
1219: --

Line 2141: from per_assignments_f

2137: -- determine the assignment_id for all the assignments of the application
2138: --
2139: cursor appl_asg is
2140: select distinct assignment_id
2141: from per_assignments_f
2142: where application_id = p_application_id;
2143: --
2144: -- events cursor -- This is only really finding applicant interviews
2145: -- since in all other cases pe.assignment_id is null

Line 2183: , per_assignments_f paf

2179: --
2180: cursor comments2(p_assignment_id NUMBER) is
2181: select h.comment_id
2182: from hr_comments h
2183: , per_assignments_f paf
2184: where h.comment_id = paf.comment_id
2185: and paf.assignment_id = p_assignment_id;
2186: --
2187: -- assignments cursor

Line 2191: from per_assignments_f paf

2187: -- assignments cursor
2188: --
2189: cursor assignments is
2190: select paf.rowid
2191: from per_assignments_f paf
2192: where paf.person_id = p_person_id
2193: and paf.application_id = p_application_id;
2194: --
2195: -- applications cursor

Line 2561: delete from per_assignments_f paf

2557: <>
2558: loop
2559: fetch assignments into l_rowid;
2560: exit when assignments%NOTFOUND;
2561: delete from per_assignments_f paf
2562: where paf.rowid = l_rowid;
2563: if sql%notfound then
2564: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2565: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');

Line 2836: FROM per_assignments_f paf

2832: -- Multi Assignment Check
2833: --
2834: CURSOR csr_multi_asg_check IS
2835: SELECT assignment_id
2836: FROM per_assignments_f paf
2837: WHERE (paf.business_group_id = p_business_group_id OR
2838: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2839: AND paf.person_id = p_person_id;
2840: --

Line 2855: FROM per_assignments_f p

2851: -- Supervisor
2852: --
2853: CURSOR csr_supervisor IS
2854: SELECT ROWID
2855: FROM per_assignments_f p
2856: WHERE (p.business_group_id = p_business_group_id OR
2857: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2858: AND p.supervisor_id = p_person_id;
2859: --

Line 2864: FROM per_assignments_f p

2860: -- recruiter cursor
2861: --
2862: CURSOR csr_recruiter IS
2863: SELECT ROWID
2864: FROM per_assignments_f p
2865: WHERE p.recruiter_id = p_person_id
2866: AND (p.business_group_id = p_business_group_id OR
2867: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y');
2868: --

Line 3352: FROM per_assignments_f p

3348: -- supervisor cursor.
3349: --
3350: CURSOR csr_supervisor IS
3351: SELECT ROWID
3352: FROM per_assignments_f p
3353: WHERE (p.business_group_id = p_business_group_id OR
3354: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
3355: AND p.supervisor_id = p_person_id;
3356: --

Line 3361: FROM per_assignments_f p

3357: -- recruiter cursor
3358: --
3359: CURSOR csr_recruiter IS
3360: SELECT ROWID
3361: FROM per_assignments_f p
3362: WHERE p.recruiter_id = p_person_id
3363: AND (p.business_group_id = p_business_group_id OR
3364: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y');
3365: --

Line 3446: FROM per_assignments_f paf

3442: CURSOR csr_assignment_rate_values IS
3443: SELECT pgr.rowid
3444: FROM pay_grade_rules_f pgr
3445: WHERE EXISTS (SELECT 'X'
3446: FROM per_assignments_f paf
3447: WHERE pgr.grade_or_spinal_point_id = paf.assignment_id
3448: and paf.business_group_id + 0 = p_business_group_id
3449: AND paf.person_id = p_person_id);
3450: --