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_ALL_ASSIGNMENTS_F

Line 40: from per_all_assignments_f paf

36: select rowid
37: from pay_personal_payment_methods ppm
38: where ppm.business_group_id = p_business_group_id
39: and exists (select 'exists'
40: from per_all_assignments_f paf
41: where paf.business_group_id +0= p_business_group_id
42: and paf.person_id = p_person_id
43: and paf.assignment_id = ppm.assignment_id
44: --start bug 5987416

Line 392: from per_all_assignments_f paf

388: select rowid
389: from pay_personal_payment_methods ppm
390: where ppm.business_group_id = p_business_group_id
391: and exists (select 'exists'
392: from per_all_assignments_f paf
393: where paf.business_group_id +0= p_business_group_id
394: and paf.person_id = p_person_id
395: and paf.assignment_id = ppm.assignment_id
396: and paf.period_of_service_id = p_primary_id

Line 650: from per_all_assignments_f a

646: -- Cursor to seelct assignment actions on or after the hire date.
647: --
648: cursor csr_assign_actions_exist is
649: select 'Y'
650: from per_all_assignments_f a
651: where a.person_id = p_person_id
652: --
653: -- 115.51 (START)
654: --

Line 662: from per_all_assignments_f b

658: --
659: AND ((a.effective_start_date = p_primary_date
660: and a.primary_flag <> 'Y'
661: and not exists ( select b.assignment_id
662: from per_all_assignments_f b
663: where nvl(b.effective_end_date,hr_api.g_eot)
664: = (p_primary_date-1)
665: and b.assignment_id = a.assignment_id) )
666: OR a.effective_start_date > p_primary_date );

Line 736: from per_all_assignments_f paf

732: select rowid
733: from per_assignment_budget_values_f pab
734: where pab.business_group_id = p_business_group_id and
735: exists (select 'budget_values exist'
736: from per_all_assignments_f paf
737: where pab.business_group_id +0= paf.business_group_id + 0
738: and paf.business_group_id +0= p_business_group_id
739: and pab.assignment_id = paf.assignment_id
740: and paf.person_id = p_person_id

Line 756: from per_all_assignments_f paf

752: select rowid
753: from pay_personal_payment_methods ppm
754: where ppm.business_group_id = p_business_group_id
755: and exists (select 'exists'
756: from per_all_assignments_f paf
757: where paf.business_group_id +0= p_business_group_id
758: and paf.person_id = p_person_id
759: and paf.assignment_id = ppm.assignment_id
760: and paf.period_of_service_id = p_primary_id

Line 1199: l_asg_status_type_id per_all_assignments_f.assignment_status_type_id%type;

1195: l_person_type_id NUMBER;
1196: -- Start of fix 3564129
1197: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
1198: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
1199: l_asg_status_type_id per_all_assignments_f.assignment_status_type_id%type;
1200: -- End of fix 3564129
1201: --
1202: -- supervisor cursor.
1203: --

Line 1270: from per_all_assignments_f paf

1266: select rowid
1267: from per_assignment_budget_values_f pab
1268: where pab.business_group_id = p_business_group_id and
1269: exists (select 'budget_values exist'
1270: from per_all_assignments_f paf
1271: where pab.business_group_id +0= paf.business_group_id + 0
1272: and paf.business_group_id +0= p_business_group_id
1273: and pab.assignment_id = paf.assignment_id
1274: and paf.person_id = p_person_id

Line 1290: from per_all_assignments_f paf

1286: select rowid
1287: from pay_personal_payment_methods ppm
1288: where ppm.business_group_id = p_business_group_id
1289: and exists (select 'exists'
1290: from per_all_assignments_f paf
1291: where paf.business_group_id +0= p_business_group_id
1292: and paf.person_id = p_person_id
1293: and paf.assignment_id = ppm.assignment_id
1294: and paf.period_of_service_id = l_period_of_service_id

Line 1307: from per_all_assignments_f paf

1303: cursor comments1 is
1304: select rowid
1305: from hr_comments h
1306: where exists (select 'comments exist'
1307: from per_all_assignments_f paf
1308: where h.comment_id = paf.comment_id
1309: and paf.business_group_id +0= p_business_group_id
1310: and paf.person_id = p_person_id
1311: and paf.period_of_service_id = l_period_of_service_id);

Line 1318: from per_all_assignments_f paf

1314: --
1315: -- VT #438579 03/05/79 added assignment_id
1316: cursor assignments is
1317: select rowid, assignment_id, assignment_status_type_id -- Bug 3564129
1318: from per_all_assignments_f paf
1319: where paf.business_group_id +0= p_business_group_id
1320: and paf.person_id = p_person_id
1321: and paf.period_of_service_id = l_period_of_service_id;
1322: --

Line 1341: from per_all_assignments_f

1337: --Added the assignment type condition of 'A' for fix of #3390818
1338: --
1339: cursor ass1 is
1340: select assignment_id,effective_start_date,ROWID
1341: from per_all_assignments_f
1342: where person_id = p_person_id
1343: and business_group_id +0 = p_business_group_id
1344: and period_of_service_id is NULL
1345: and assignment_type in ('E','A') -- 3194314

Line 1352: from per_all_assignments_f paf

1348: --
1349: --
1350: cursor c_assignments is
1351: select paf.assignment_id, paf.effective_start_date
1352: from per_all_assignments_f paf
1353: where paf.person_id = p_person_id
1354: and paf.business_group_id +0 = p_business_group_id
1355: and assignment_type <> 'B'; --modified for bug #6449599
1356: --

Line 1363: from per_all_assignments_f paf

1359: cursor applications is
1360: select rowid
1361: from per_applications pap
1362: where exists (select 'row exists'
1363: from per_all_assignments_f paf
1364: where paf.person_id = p_person_id
1365: and paf.business_group_id +0 = p_business_group_id
1366: and paf.period_of_service_id is NULL
1367: and paf.effective_end_date = p_date_start - 1

Line 1512: update per_all_assignments_f paf

1508: fetch supervisor1 into p_rowid;
1509: exit when supervisor1%NOTFOUND;
1510: --
1511: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',50);
1512: update per_all_assignments_f paf
1513: set paf.supervisor_id = NULL
1514: where paf.rowid = p_rowid;
1515: --
1516: if sql%notfound then

Line 1533: update per_all_assignments_f paf

1529: fetch recruiter1 into p_rowid;
1530: exit when recruiter1%NOTFOUND;
1531: --
1532: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',80);
1533: update per_all_assignments_f paf
1534: set paf.recruiter_id = NULL
1535: where paf.rowid = p_rowid;
1536: --
1537: if sql%notfound then

Line 1742: delete from per_all_assignments_f paf

1738: -- fix for bug 5005157 ends here.
1739:
1740:
1741: -- End of fix 3564129
1742: delete from per_all_assignments_f paf
1743: where paf.rowid = p_rowid;
1744: if sql%notfound then
1745: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1746: hr_utility.set_message_token('PROCEDURE','do_cancel_hire');

Line 1779: update per_all_assignments_f paf

1775: loop
1776: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',280);
1777: fetch ass1 into p_assignment_id,p_start_date,p_rowid;
1778: exit when ass1%NOTFOUND;
1779: update per_all_assignments_f paf
1780: set paf.effective_end_date = p_end_of_time
1781: where paf.rowid = p_rowid;
1782: --
1783: hrentmnt.maintain_entries_asg(p_assignment_id

Line 2329: from per_all_assignments_f paf

2325: --
2326: -- Cursor to re-evaluate the security.
2327: cursor csr_asg_sec is
2328: select paf.assignment_id, paf.effective_start_date
2329: from per_all_assignments_f paf
2330: where paf.person_id = p_person_id
2331: and paf.assignment_type <> 'B'; -- Added For Bug # 6630290
2332: --
2333: l_rowid VARCHAR2(18);

Line 2918: FROM per_all_assignments_f paf

2914: SELECT ROWID
2915: FROM per_assignment_budget_values_f pab
2916: WHERE pab.business_group_id = p_business_group_id and
2917: EXISTS (SELECT 'budget_values exist'
2918: FROM per_all_assignments_f paf
2919: WHERE pab.business_group_id +0= paf.business_group_id + 0
2920: AND paf.business_group_id +0= p_business_group_id
2921: AND pab.assignment_id = paf.assignment_id
2922: AND paf.person_id = p_person_id

Line 2939: FROM per_all_assignments_f paf

2935: SELECT ROWID
2936: FROM pay_personal_payment_methods ppm
2937: WHERE ppm.business_group_id = p_business_group_id
2938: AND EXISTS (SELECT 'exists'
2939: FROM per_all_assignments_f paf
2940: WHERE paf.business_group_id +0= p_business_group_id
2941: AND paf.person_id = p_person_id
2942: AND paf.assignment_id = ppm.assignment_id
2943: AND paf.period_of_placement_date_start = p_date_start

Line 3317: FROM per_all_assignments_f paf

3313: SELECT ROWID
3314: FROM per_assignment_budget_values_f pab
3315: WHERE pab.business_group_id = p_business_group_id and
3316: EXISTS (SELECT 'budget_values exist'
3317: FROM per_all_assignments_f paf
3318: WHERE pab.business_group_id +0= paf.business_group_id + 0
3319: AND paf.business_group_id +0= p_business_group_id
3320: AND pab.assignment_id = paf.assignment_id
3321: AND paf.person_id = p_person_id

Line 3337: FROM per_all_assignments_f paf

3333: SELECT ROWID
3334: FROM pay_personal_payment_methods ppm
3335: WHERE ppm.business_group_id = p_business_group_id
3336: AND EXISTS (SELECT 'exists'
3337: FROM per_all_assignments_f paf
3338: WHERE paf.business_group_id +0= p_business_group_id
3339: AND paf.person_id = p_person_id
3340: AND paf.assignment_id = ppm.assignment_id
3341: AND paf.period_of_placement_date_start = p_date_start

Line 3382: FROM per_all_assignments_f paf

3378: CURSOR csr_comments IS
3379: SELECT ROWID
3380: FROM hr_comments h
3381: WHERE EXISTS (SELECT 'comments exist'
3382: FROM per_all_assignments_f paf
3383: WHERE h.comment_id = paf.comment_id
3384: AND paf.business_group_id +0 = p_business_group_id
3385: AND paf.person_id = p_person_id
3386: AND paf.period_of_placement_date_start = p_date_start);

Line 3395: FROM per_all_assignments_f paf

3391: --
3392: CURSOR csr_assignments1 IS
3393: SELECT ROWID,
3394: assignment_id
3395: FROM per_all_assignments_f paf
3396: WHERE paf.business_group_id +0 = p_business_group_id
3397: AND paf.person_id = p_person_id
3398: AND paf.period_of_placement_date_start = p_date_start;
3399: --

Line 3406: FROM per_all_assignments_f

3402: CURSOR csr_assignments2 IS
3403: SELECT assignment_id,
3404: effective_start_date,
3405: ROWID
3406: FROM per_all_assignments_f
3407: WHERE person_id = p_person_id
3408: AND business_group_id +0 = p_business_group_id
3409: AND effective_end_date = p_date_start - 1
3410: AND assignment_type = 'C' -- 3194314

Line 3419: FROM per_all_assignments_f paf

3415: CURSOR csr_applications IS
3416: SELECT ROWID
3417: FROM per_applications pap
3418: WHERE EXISTS (SELECT 'row exists'
3419: FROM per_all_assignments_f paf
3420: WHERE paf.person_id = p_person_id
3421: AND paf.business_group_id +0 = p_business_group_id
3422: AND paf.effective_end_date = p_date_start - 1
3423: AND pap.application_id = paf.application_id);

Line 3515: from per_all_assignments_f paf

3511: AND ptu.effective_end_date;
3512: --
3513: cursor csr_asg_sec is
3514: select paf.assignment_id, paf.effective_start_date
3515: from per_all_assignments_f paf
3516: where paf.person_id = p_person_id
3517: and paf.business_group_id +0 = p_business_group_id
3518: and paf.assignment_type <> 'B'; -- Added For Bug # 6630290
3519:

Line 3535: UPDATE per_all_assignments_f paf

3531: FOR supervisor_rec IN csr_supervisor LOOP
3532: --
3533: hr_utility.set_location(l_proc,60);
3534: --
3535: UPDATE per_all_assignments_f paf
3536: SET paf.supervisor_id = NULL
3537: WHERE paf.rowid = supervisor_rec.rowid;
3538: --
3539: IF sql%notfound THEN

Line 3556: UPDATE per_all_assignments_f paf

3552: FOR recruiter_rec IN csr_recruiter LOOP
3553: --
3554: hr_utility.set_location(l_proc,80);
3555: --
3556: UPDATE per_all_assignments_f paf
3557: SET paf.recruiter_id = NULL
3558: WHERE paf.rowid = recruiter_rec.rowid;
3559: --
3560: IF SQL%NOTFOUND THEN

Line 3720: DELETE FROM per_all_assignments_f paf

3716: WHERE pca.assignment_id = assignment1_rec.assignment_id;
3717: --
3718: hr_utility.set_location(l_proc,260);
3719: --
3720: DELETE FROM per_all_assignments_f paf
3721: WHERE paf.rowid = assignment1_rec.rowid;
3722: --
3723: IF SQL%NOTFOUND THEN
3724: --

Line 3858: UPDATE per_all_assignments_f paf

3854: FOR assignment2_rec IN csr_assignments2 LOOP
3855: --
3856: hr_utility.set_location(l_proc,300);
3857: --
3858: UPDATE per_all_assignments_f paf
3859: SET paf.effective_end_date = l_end_of_time
3860: WHERE paf.rowid = assignment2_rec.rowid;
3861: --
3862: hr_utility.set_location(l_proc,310);