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 FND_PROFILE

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

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;
74: --
75: -- events cursor
76: --

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

79: from per_events pe
80: , per_bookings pb
81: where pe.business_group_id = pb.business_group_id
82: and (pb.business_group_id = p_business_group_id OR
83: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
84: and pe.event_id = pb.event_id
85: and pe.event_or_interview in ('I','E')
86: and pb.person_id = p_person_id
87: for update of pb.event_id;

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

91: cursor vacancies is
92: select rowid
93: from per_vacancies pv
94: where (pv.business_group_id = p_business_group_id OR
95: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
96: and pv.recruiter_id = p_person_id
97: and pv.date_from >= p_effective_date
98: for update of pv.vacancy_id;
99: --

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

102: cursor requisitions is
103: select rowid
104: from per_requisitions pr
105: where (pr.business_group_id = p_business_group_id OR
106: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
107: and pr.person_id = p_person_id
108: for update of person_id;
109: --
110: cursor supervisor is

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

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;
117: --
118: cursor per_rows is

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

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;
329: --
330: -- recruiter cursor

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

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;
339: --
340: -- events cursor
341: --

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

344: from per_events pe
345: , per_bookings pb
346: where pe.business_group_id = pb.business_group_id
347: and (pb.business_group_id = p_business_group_id OR
348: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
349: and pe.event_id = pb.event_id
350: and pe.event_or_interview = p_type
351: and pb.person_id = p_person_id
352: for update of pb.event_id;

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

356: cursor vacancies is
357: select rowid
358: from per_vacancies pv
359: where (pv.business_group_id = p_business_group_id OR
360: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
361: and pv.recruiter_id = p_person_id
362: and pv.date_from >= p_primary_date
363: for update of pv.vacancy_id;
364: --

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

367: cursor requisitions is
368: select rowid
369: from per_requisitions pr
370: where (pr.business_group_id = p_business_group_id OR
371: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
372: and pr.person_id = p_person_id
373: for update of person_id;
374: --
375: -- absenses cursor

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

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: --
678: -- recruiter cursor
679: --

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

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: --
687: -- reviews or Events cursor
688: --
689: cursor reviews_or_events(p_type varchar2) is

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

691: from per_events pe
692: , per_bookings pb
693: where pe.business_group_id = pb.business_group_id
694: and (pb.business_group_id = p_business_group_id OR
695: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
696: and pe.event_id = pb.event_id
697: and pe.event_or_interview = p_type
698: and pb.person_id = p_person_id;
699: --

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

702: cursor interviews is
703: select 'Interviews exist'
704: from per_events pe
705: where (pe.business_group_id = p_business_group_id OR
706: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
707: and pe.event_or_interview = 'I'
708: and pe.internal_contact_person_id = p_person_id;
709: --
710: -- vacancies cursor

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

712: cursor vacancy is
713: select rowid
714: from per_vacancies pv
715: where (pv.business_group_id = p_business_group_id OR
716: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
717: and pv.recruiter_id = p_person_id
718: and pv.date_from >= p_primary_date;
719: --
720: -- requisitions cursor

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

722: cursor requisition is
723: select rowid
724: from per_requisitions pr
725: where (pr.business_group_id = p_business_group_id OR
726: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
727: and pr.person_id = p_person_id;
728: --
729: -- budget_values cursor
730: --

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

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: --
1211: -- recruiter cursor
1212: --

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

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: --
1220: -- events cursor
1221: --
1222: cursor events is

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

1222: cursor events is
1223: select rowid
1224: from per_bookings pb
1225: where (pb.business_group_id = p_business_group_id OR
1226: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1227: and pb.person_id = p_person_id
1228: and exists ( select 'row exists'
1229: from per_events pe
1230: where pe.business_group_id + 0 = p_business_group_id

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

1237: cursor vacancies is
1238: select rowid
1239: from per_vacancies pv
1240: where (pv.business_group_id = p_business_group_id OR
1241: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1242: and pv.recruiter_id = p_person_id
1243: and pv.date_from >= p_date_start;
1244: --
1245: -- requisitions cursor

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

1247: cursor requisitions1 is
1248: select rowid
1249: from per_requisitions pr
1250: where (pr.business_group_id = p_business_group_id OR
1251: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1252: and pr.person_id = p_person_id;
1253: --
1254: -- absenses cursor
1255: --

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

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: --
2841: -- Check person is a CWK
2842: --

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

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: --
2860: -- recruiter cursor
2861: --

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

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: --
2869: -- reviews or Events cursor
2870: --
2871: CURSOR csr_reviews_or_events(p_type varchar2) IS

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

2873: FROM per_events pe,
2874: per_bookings pb
2875: WHERE pe.business_group_id = pb.business_group_id
2876: AND (pb.business_group_id = p_business_group_id OR
2877: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2878: AND pe.event_id = pb.event_id
2879: AND pe.event_or_interview = p_type
2880: AND pb.person_id = p_person_id;
2881: --

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

2884: CURSOR csr_interviews IS
2885: SELECT 'Interviews exist'
2886: FROM per_events pe
2887: WHERE (pe.business_group_id = p_business_group_id OR
2888: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2889: AND pe.event_or_interview = 'I'
2890: AND pe.internal_contact_person_id = p_person_id;
2891: --
2892: -- vacancies cursor

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

2894: CURSOR csr_vacancy IS
2895: SELECT ROWID
2896: FROM per_vacancies pv
2897: WHERE (pv.business_group_id = p_business_group_id OR
2898: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2899: AND pv.recruiter_id = p_person_id
2900: AND pv.date_from >= l_effective_date;
2901: --
2902: -- requisitions cursor

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

2904: CURSOR csr_requisition IS
2905: SELECT ROWID
2906: FROM per_requisitions pr
2907: WHERE (pr.business_group_id = p_business_group_id OR
2908: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2909: AND pr.person_id = p_person_id;
2910: --
2911: -- budget_values cursor
2912: --

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

3288: CURSOR csr_events IS
3289: SELECT ROWID
3290: FROM per_bookings pb
3291: WHERE (pb.business_group_id = p_business_group_id OR
3292: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
3293: AND pb.person_id = p_person_id
3294: AND EXISTS (SELECT 'row exists'
3295: FROM per_events pe
3296: WHERE pe.business_group_id + 0 = p_business_group_id

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

3303: CURSOR csr_requisitions IS
3304: SELECT ROWID
3305: FROM per_requisitions pr
3306: WHERE (pr.business_group_id = p_business_group_id OR
3307: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
3308: AND pr.person_id = p_person_id;
3309: --
3310: -- budget_values cursor
3311: --

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

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: --
3357: -- recruiter cursor
3358: --

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

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: --
3366: -- vacancies cursor
3367: --
3368: CURSOR csr_vacancies IS

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

3368: CURSOR csr_vacancies IS
3369: SELECT ROWID
3370: FROM per_vacancies pv
3371: WHERE (pv.business_group_id = p_business_group_id OR
3372: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
3373: AND pv.recruiter_id = p_person_id
3374: AND pv.date_from >= p_date_start;
3375: --
3376: -- comments cursor