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.

[Home] [Help]

APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on FND_PROFILE

Line 240: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

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;
242: --
243: -- events cursor
244: --

Line 251: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

247: from per_events pe
248: , per_bookings pb
249: where pe.business_group_id = pb.business_group_id
250: and (pb.business_group_id = p_business_group_id OR
251: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
252: and pe.event_id = pb.event_id
253: and pe.event_or_interview in ('I','E')
254: and pb.person_id = p_person_id
255: for update of pb.event_id;

Line 263: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

259: cursor vacancies is
260: select rowid
261: from per_vacancies pv
262: where (pv.business_group_id = p_business_group_id OR
263: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
264: and pv.recruiter_id = p_person_id
265: and pv.date_from >= p_effective_date
266: for update of pv.vacancy_id;
267: --

Line 274: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

270: cursor requisitions is
271: select rowid
272: from per_requisitions pr
273: where (pr.business_group_id = p_business_group_id OR
274: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
275: and pr.person_id = p_person_id
276: for update of person_id;
277: --
278: cursor supervisor is

Line 282: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

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;
285: --
286: cursor per_rows is

Line 494: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

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;
497: --
498: -- recruiter cursor

Line 505: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

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;
507: --
508: -- events cursor
509: --

Line 516: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

512: from per_events pe
513: , per_bookings pb
514: where pe.business_group_id = pb.business_group_id
515: and (pb.business_group_id = p_business_group_id OR
516: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
517: and pe.event_id = pb.event_id
518: and pe.event_or_interview = p_type
519: and pb.person_id = p_person_id
520: for update of pb.event_id;

Line 528: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

524: cursor vacancies is
525: select rowid
526: from per_vacancies pv
527: where (pv.business_group_id = p_business_group_id OR
528: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
529: and pv.recruiter_id = p_person_id
530: and pv.date_from >= p_primary_date
531: for update of pv.vacancy_id;
532: --

Line 539: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

535: cursor requisitions is
536: select rowid
537: from per_requisitions pr
538: where (pr.business_group_id = p_business_group_id OR
539: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
540: and pr.person_id = p_person_id
541: for update of person_id;
542: --
543: -- absenses cursor

Line 843: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

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
846: and p.effective_end_date >= p_primary_date
847: and p.assignment_type in ('E','C')

Line 864: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

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
866: and p.effective_end_date >= p_primary_date
867: and p.assignment_type = 'A';
868: --end changes for bug 9304366;

Line 878: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

874: from per_events pe
875: , per_bookings pb
876: where pe.business_group_id = pb.business_group_id
877: and (pb.business_group_id = p_business_group_id OR
878: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
879: and pe.event_id = pb.event_id
880: and pe.event_or_interview = p_type
881: and pb.person_id = p_person_id;
882: --

Line 889: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

885: cursor interviews is
886: select 'Interviews exist'
887: from per_events pe
888: where (pe.business_group_id = p_business_group_id OR
889: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
890: and pe.event_or_interview = 'I'
891: and pe.internal_contact_person_id = p_person_id;
892: --
893: -- vacancies cursor

Line 899: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

895: cursor vacancy is
896: select rowid
897: from per_vacancies pv
898: where (pv.business_group_id = p_business_group_id OR
899: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
900: and pv.recruiter_id = p_person_id
901: and pv.date_from >= p_primary_date;
902: --
903: -- requisitions cursor

Line 909: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

905: cursor requisition is
906: select rowid
907: from per_requisitions pr
908: where (pr.business_group_id = p_business_group_id OR
909: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
910: and pr.person_id = p_person_id
911: and pr.date_from >= p_primary_date; -- added for bug 9304366
912: --
913: -- budget_values cursor

Line 2103: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

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
2106: and p.effective_end_date >= p_date_start
2107: and p.assignment_type in ('E','C')

Line 2124: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

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
2126: and p.effective_end_date >= p_date_start
2127: and p.assignment_type = 'A';
2128: --end changes for bug 9304366

Line 2136: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

2132: cursor events is
2133: select rowid
2134: from per_bookings pb
2135: where (pb.business_group_id = p_business_group_id OR
2136: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2137: and pb.person_id = p_person_id
2138: and exists ( select 'row exists'
2139: from per_events pe
2140: where pe.business_group_id + 0 = p_business_group_id

Line 2151: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

2147: cursor vacancies is
2148: select rowid
2149: from per_vacancies pv
2150: where (pv.business_group_id = p_business_group_id OR
2151: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2152: and pv.recruiter_id = p_person_id
2153: and pv.date_from >= p_date_start;
2154: --
2155: -- requisitions cursor

Line 2161: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

2157: cursor requisitions1 is
2158: select rowid
2159: from per_requisitions pr
2160: where (pr.business_group_id = p_business_group_id OR
2161: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2162: and pr.person_id = p_person_id
2163: and pr.date_from >= p_date_start; -- added for bug 9304366
2164: --
2165: -- absenses cursor

Line 4004: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

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: --
4007: -- Check person is a CWK
4008: --

Line 4023: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

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
4026: and p.effective_end_date >= p_date_start
4027: and p.assignment_type in ('E','C')

Line 4045: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y');

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: --
4047: -- reviews or Events cursor
4048: --
4049: CURSOR csr_reviews_or_events(p_type varchar2) IS

Line 4055: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

4051: FROM per_events pe,
4052: per_bookings pb
4053: WHERE pe.business_group_id = pb.business_group_id
4054: AND (pb.business_group_id = p_business_group_id OR
4055: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4056: AND pe.event_id = pb.event_id
4057: AND pe.event_or_interview = p_type
4058: AND pb.person_id = p_person_id;
4059: --

Line 4066: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

4062: CURSOR csr_interviews IS
4063: SELECT 'Interviews exist'
4064: FROM per_events pe
4065: WHERE (pe.business_group_id = p_business_group_id OR
4066: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4067: AND pe.event_or_interview = 'I'
4068: AND pe.internal_contact_person_id = p_person_id;
4069: --
4070: -- vacancies cursor

Line 4076: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

4072: CURSOR csr_vacancy IS
4073: SELECT ROWID
4074: FROM per_vacancies pv
4075: WHERE (pv.business_group_id = p_business_group_id OR
4076: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4077: AND pv.recruiter_id = p_person_id
4078: AND pv.date_from >= l_effective_date;
4079: --
4080: -- requisitions cursor

Line 4086: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

4082: CURSOR csr_requisition IS
4083: SELECT ROWID
4084: FROM per_requisitions pr
4085: WHERE (pr.business_group_id = p_business_group_id OR
4086: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4087: AND pr.person_id = p_person_id;
4088: --
4089: -- budget_values cursor
4090: --

Line 4507: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

4503: CURSOR csr_events IS
4504: SELECT ROWID
4505: FROM per_bookings pb
4506: WHERE (pb.business_group_id = p_business_group_id OR
4507: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4508: AND pb.person_id = p_person_id
4509: AND EXISTS (SELECT 'row exists'
4510: FROM per_events pe
4511: WHERE pe.business_group_id + 0 = p_business_group_id

Line 4522: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

4518: CURSOR csr_requisitions IS
4519: SELECT ROWID
4520: FROM per_requisitions pr
4521: WHERE (pr.business_group_id = p_business_group_id OR
4522: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4523: AND pr.person_id = p_person_id;
4524: --
4525: -- budget_values cursor
4526: --

Line 4569: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

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
4572: and p.effective_end_date >= p_date_start
4573: and p.assignment_type in ('E','C')

Line 4591: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y');

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: --
4593: -- vacancies cursor
4594: --
4595: CURSOR csr_vacancies IS

Line 4599: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

4595: CURSOR csr_vacancies IS
4596: SELECT ROWID
4597: FROM per_vacancies pv
4598: WHERE (pv.business_group_id = p_business_group_id OR
4599: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4600: AND pv.recruiter_id = p_person_id
4601: AND pv.date_from >= p_date_start;
4602: --
4603: -- comments cursor