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.IRC_UTILITIES_PKG dependencies on PER_ALL_PEOPLE_F

Line 113: FUNCTION GET_CURRENT_EMPLOYER (p_person_id per_all_people_f.person_id%TYPE,

109: -- ----------------------------------------------------------------------------
110: -- |-----------------------< GET_CURRENT_EMPLOYER >--------------------------|
111: -- ----------------------------------------------------------------------------
112:
113: FUNCTION GET_CURRENT_EMPLOYER (p_person_id per_all_people_f.person_id%TYPE,
114: p_eff_date date )
115: RETURN VARCHAR2
116:
117: IS

Line 126: PER_ALL_PEOPLE_F ppf,

122: CURSOR c_current_employers(p_person_id PER_PREVIOUS_EMPLOYERS.PERSON_ID%TYPE,
123: p_date PER_PREVIOUS_EMPLOYERS.END_DATE%TYPE) IS
124: SELECT empl.EMPLOYER_NAME
125: FROM PER_PREVIOUS_EMPLOYERS empl,
126: PER_ALL_PEOPLE_F ppf,
127: PER_ALL_PEOPLE_F ppf2
128: WHERE ppf.person_id = p_person_id
129: AND ppf.party_id = ppf2.party_id
130: AND p_date BETWEEN ppf.effective_start_date and ppf.effective_end_date

Line 127: PER_ALL_PEOPLE_F ppf2

123: p_date PER_PREVIOUS_EMPLOYERS.END_DATE%TYPE) IS
124: SELECT empl.EMPLOYER_NAME
125: FROM PER_PREVIOUS_EMPLOYERS empl,
126: PER_ALL_PEOPLE_F ppf,
127: PER_ALL_PEOPLE_F ppf2
128: WHERE ppf.person_id = p_person_id
129: AND ppf.party_id = ppf2.party_id
130: AND p_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
131: AND p_date BETWEEN ppf2.effective_start_date and ppf2.effective_end_date

Line 161: FROM per_all_people_f ppf

157:
158: IS
159: CURSOR c_current_employers IS
160: SELECT ppe.employer_name
161: FROM per_all_people_f ppf
162: ,per_previous_employers ppe
163: WHERE ppf.party_id = p_party_id
164: AND p_eff_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
165: AND ppe.person_id = ppf.person_id

Line 188: FUNCTION GET_MAX_QUAL_TYPE (p_person_id per_all_people_f.person_id%TYPE)

184:
185: -- ----------------------------------------------------------------------------
186: -- |-------------------------< GET_MAX_QUAL_TYPE >---------------------------|
187: -- ----------------------------------------------------------------------------
188: FUNCTION GET_MAX_QUAL_TYPE (p_person_id per_all_people_f.person_id%TYPE)
189: RETURN VARCHAR2
190:
191: IS
192:

Line 197: CURSOR c_qual_types(p_person PER_ALL_PEOPLE_F.PERSON_ID%TYPE) IS

193: l_qual_type PER_QUALIFICATION_TYPES.NAME%TYPE;
194: l_qual_type2 PER_QUALIFICATION_TYPES.NAME%TYPE;
195: l_max_rank number;
196:
197: CURSOR c_qual_types(p_person PER_ALL_PEOPLE_F.PERSON_ID%TYPE) IS
198: SELECT QTYP.NAME,qtyp.rank
199: FROM PER_QUALIFICATION_TYPES QTYP,
200: PER_QUALIFICATIONS QUAL,
201: PER_ALL_PEOPLE_F ppf,

Line 201: PER_ALL_PEOPLE_F ppf,

197: CURSOR c_qual_types(p_person PER_ALL_PEOPLE_F.PERSON_ID%TYPE) IS
198: SELECT QTYP.NAME,qtyp.rank
199: FROM PER_QUALIFICATION_TYPES QTYP,
200: PER_QUALIFICATIONS QUAL,
201: PER_ALL_PEOPLE_F ppf,
202: PER_ALL_PEOPLE_F ppf2
203: WHERE ppf.person_id = p_person
204: AND ppf.party_id = ppf2.party_id
205: AND trunc(sysdate) BETWEEN ppf.effective_start_date and ppf.effective_end_date

Line 202: PER_ALL_PEOPLE_F ppf2

198: SELECT QTYP.NAME,qtyp.rank
199: FROM PER_QUALIFICATION_TYPES QTYP,
200: PER_QUALIFICATIONS QUAL,
201: PER_ALL_PEOPLE_F ppf,
202: PER_ALL_PEOPLE_F ppf2
203: WHERE ppf.person_id = p_person
204: AND ppf.party_id = ppf2.party_id
205: AND trunc(sysdate) BETWEEN ppf.effective_start_date and ppf.effective_end_date
206: AND trunc(sysdate) BETWEEN ppf2.effective_start_date and ppf2.effective_end_date

Line 211: CURSOR c_qual_types2(p_person PER_ALL_PEOPLE_F.PERSON_ID%TYPE

207: AND ppf2.person_id = QUAL.PERSON_ID
208: AND QUAL.QUALIFICATION_TYPE_ID = QTYP.QUALIFICATION_TYPE_ID
209: order by QTYP.RANK desc, qual.awarded_date desc, qual.creation_date desc;
210:
211: CURSOR c_qual_types2(p_person PER_ALL_PEOPLE_F.PERSON_ID%TYPE
212: ,p_max_rank number) IS
213: SELECT QTYP.NAME
214: FROM PER_QUALIFICATION_TYPES QTYP,
215: PER_QUALIFICATIONS QUAL,

Line 217: PER_ALL_PEOPLE_F ppf,

213: SELECT QTYP.NAME
214: FROM PER_QUALIFICATION_TYPES QTYP,
215: PER_QUALIFICATIONS QUAL,
216: PER_ESTABLISHMENT_ATTENDANCES ESTAB,
217: PER_ALL_PEOPLE_F ppf,
218: PER_ALL_PEOPLE_F ppf2
219: WHERE ppf.person_id = p_person
220: AND ppf.party_id = ppf2.party_id
221: AND trunc(sysdate) BETWEEN ppf.effective_start_date and ppf.effective_end_date

Line 218: PER_ALL_PEOPLE_F ppf2

214: FROM PER_QUALIFICATION_TYPES QTYP,
215: PER_QUALIFICATIONS QUAL,
216: PER_ESTABLISHMENT_ATTENDANCES ESTAB,
217: PER_ALL_PEOPLE_F ppf,
218: PER_ALL_PEOPLE_F ppf2
219: WHERE ppf.person_id = p_person
220: AND ppf.party_id = ppf2.party_id
221: AND trunc(sysdate) BETWEEN ppf.effective_start_date and ppf.effective_end_date
222: AND trunc(sysdate) BETWEEN ppf2.effective_start_date and ppf2.effective_end_date

Line 265: PER_ALL_PEOPLE_F ppf

261: CURSOR c_qual_types IS
262: SELECT QTYP.NAME
263: FROM PER_QUALIFICATION_TYPES QTYP,
264: PER_QUALIFICATIONS QUAL,
265: PER_ALL_PEOPLE_F ppf
266: WHERE ppf.party_id = p_party_id
267: AND trunc(sysdate) BETWEEN ppf.effective_start_date and ppf.effective_end_date
268: AND ppf.person_id = QUAL.PERSON_ID
269: AND QUAL.QUALIFICATION_TYPE_ID = QTYP.QUALIFICATION_TYPE_ID

Line 277: PER_ALL_PEOPLE_F ppf

273: SELECT /*+ FIRST_ROWS */ QTYP.NAME
274: FROM PER_QUALIFICATION_TYPES QTYP,
275: PER_QUALIFICATIONS QUAL,
276: PER_ESTABLISHMENT_ATTENDANCES ESTAB,
277: PER_ALL_PEOPLE_F ppf
278: WHERE ppf.party_id = p_party_id
279: AND trunc(sysdate) BETWEEN ppf.effective_start_date and ppf.effective_end_date
280: AND ppf.person_id = ESTAB.PERSON_ID
281: AND estab.attendance_id=qual.attendance_id

Line 322: FUNCTION GET_EMP_UPT_FOR_PERSON (p_person_id per_all_people_f.person_id%TYPE,

318: -- ----------------------------------------------------------------------------
319: -- |-----------------------< GET_EMP_UPT_FOR_PERSON >-------------------------|
320: -- ----------------------------------------------------------------------------
321:
322: FUNCTION GET_EMP_UPT_FOR_PERSON (p_person_id per_all_people_f.person_id%TYPE,
323: p_eff_date date )
324: RETURN VARCHAR2
325: IS
326: CURSOR csr_emp_person_types

Line 332: ,PER_ALL_PEOPLE_F ppf

328: SELECT ttl.user_person_type
329: FROM per_person_types_tl ttl
330: ,per_person_types typ
331: ,per_person_type_usages_f ptu
332: ,PER_ALL_PEOPLE_F ppf
333: ,PER_ALL_PEOPLE_F ppf2
334: WHERE ppf.person_id = p_person_id
335: AND ppf.party_id = ppf2.party_id
336: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date

Line 333: ,PER_ALL_PEOPLE_F ppf2

329: FROM per_person_types_tl ttl
330: ,per_person_types typ
331: ,per_person_type_usages_f ptu
332: ,PER_ALL_PEOPLE_F ppf
333: ,PER_ALL_PEOPLE_F ppf2
334: WHERE ppf.person_id = p_person_id
335: AND ppf.party_id = ppf2.party_id
336: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
337: AND p_eff_date BETWEEN ppf2.effective_start_date and ppf2.effective_end_date

Line 376: ,PER_ALL_PEOPLE_F ppf

372: SELECT ttl.user_person_type
373: FROM per_person_types_tl ttl
374: ,per_person_types typ
375: ,per_person_type_usages_f ptu
376: ,PER_ALL_PEOPLE_F ppf
377: WHERE ppf.party_id = p_party_id
378: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
379: AND ppf.person_id = ptu.person_id
380: AND ttl.language = userenv('LANG')

Line 412: FUNCTION GET_APL_UPT_FOR_PERSON (p_person_id per_all_people_f.person_id%TYPE,

408: -- ----------------------------------------------------------------------------
409: -- |-----------------------< GET_APL_UPT_FOR_PERSON >------------------------|
410: -- ----------------------------------------------------------------------------
411:
412: FUNCTION GET_APL_UPT_FOR_PERSON (p_person_id per_all_people_f.person_id%TYPE,
413: p_eff_date date )
414: RETURN VARCHAR2
415: IS
416: CURSOR csr_emp_person_type_exists

Line 430: ,PER_ALL_PEOPLE_F ppf

426: SELECT ttl.user_person_type
427: FROM per_person_types_tl ttl
428: ,per_person_types typ
429: ,per_person_type_usages_f ptu
430: ,PER_ALL_PEOPLE_F ppf
431: ,PER_ALL_PEOPLE_F ppf2
432: WHERE ppf.person_id = p_person_id
433: AND ppf.party_id = ppf2.party_id
434: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date

Line 431: ,PER_ALL_PEOPLE_F ppf2

427: FROM per_person_types_tl ttl
428: ,per_person_types typ
429: ,per_person_type_usages_f ptu
430: ,PER_ALL_PEOPLE_F ppf
431: ,PER_ALL_PEOPLE_F ppf2
432: WHERE ppf.person_id = p_person_id
433: AND ppf.party_id = ppf2.party_id
434: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
435: AND p_eff_date BETWEEN ppf2.effective_start_date and ppf2.effective_end_date

Line 484: ,PER_ALL_PEOPLE_F ppf

480: SELECT ttl.user_person_type
481: FROM per_person_types_tl ttl
482: ,per_person_types typ
483: ,per_person_type_usages_f ptu
484: ,PER_ALL_PEOPLE_F ppf
485: WHERE ppf.party_id = p_party_id
486: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
487: AND ppf.person_id = ptu.person_id
488: AND ttl.language = userenv('LANG')

Line 518: FUNCTION GET_EMP_SPT_FOR_PERSON (p_person_id per_all_people_f.person_id%TYPE,

514: -- ----------------------------------------------------------------------------
515: -- |-----------------------< GET_EMP_SPT_FOR_PERSON >-------------------------|
516: -- ----------------------------------------------------------------------------
517:
518: FUNCTION GET_EMP_SPT_FOR_PERSON (p_person_id per_all_people_f.person_id%TYPE,
519: p_eff_date date ) RETURN VARCHAR2
520: IS
521: CURSOR csr_emp_person_types
522: IS

Line 526: ,PER_ALL_PEOPLE_F ppf

522: IS
523: SELECT typ.system_person_type
524: FROM per_person_types typ
525: ,per_person_type_usages_f ptu
526: ,PER_ALL_PEOPLE_F ppf
527: ,PER_ALL_PEOPLE_F ppf2
528: WHERE ppf.person_id = p_person_id
529: AND ppf.party_id = ppf2.party_id
530: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date

Line 527: ,PER_ALL_PEOPLE_F ppf2

523: SELECT typ.system_person_type
524: FROM per_person_types typ
525: ,per_person_type_usages_f ptu
526: ,PER_ALL_PEOPLE_F ppf
527: ,PER_ALL_PEOPLE_F ppf2
528: WHERE ppf.person_id = p_person_id
529: AND ppf.party_id = ppf2.party_id
530: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
531: AND p_eff_date BETWEEN ppf2.effective_start_date and ppf2.effective_end_date

Line 558: (p_person_id IN per_all_people_f.person_id%TYPE

554: -- |---------------------< get_recruitment_person_id >-------------------|
555: -- -------------------------------------------------------------------------
556: --
557: FUNCTION GET_RECRUITMENT_PERSON_ID
558: (p_person_id IN per_all_people_f.person_id%TYPE
559: ,p_effective_date IN per_all_people_f.effective_start_date%TYPE)
560: RETURN per_all_people_f.person_id%TYPE
561:
562: IS

Line 559: ,p_effective_date IN per_all_people_f.effective_start_date%TYPE)

555: -- -------------------------------------------------------------------------
556: --
557: FUNCTION GET_RECRUITMENT_PERSON_ID
558: (p_person_id IN per_all_people_f.person_id%TYPE
559: ,p_effective_date IN per_all_people_f.effective_start_date%TYPE)
560: RETURN per_all_people_f.person_id%TYPE
561:
562: IS
563: --

Line 560: RETURN per_all_people_f.person_id%TYPE

556: --
557: FUNCTION GET_RECRUITMENT_PERSON_ID
558: (p_person_id IN per_all_people_f.person_id%TYPE
559: ,p_effective_date IN per_all_people_f.effective_start_date%TYPE)
560: RETURN per_all_people_f.person_id%TYPE
561:
562: IS
563: --
564: -- cursor to find party with a notification preference

Line 569: FROM PER_ALL_PEOPLE_F PPF,

565: --
566: CURSOR csr_person_with_notif_prefs(p_person_id NUMBER
567: ,p_effective_date DATE) IS
568: SELECT inp.person_id
569: FROM PER_ALL_PEOPLE_F PPF,
570: IRC_NOTIFICATION_PREFERENCES INP,
571: PER_ALL_PEOPLE_F PPF2
572: WHERE ppf.person_id = p_person_id
573: AND p_effective_date BETWEEN ppf.effective_start_date

Line 571: PER_ALL_PEOPLE_F PPF2

567: ,p_effective_date DATE) IS
568: SELECT inp.person_id
569: FROM PER_ALL_PEOPLE_F PPF,
570: IRC_NOTIFICATION_PREFERENCES INP,
571: PER_ALL_PEOPLE_F PPF2
572: WHERE ppf.person_id = p_person_id
573: AND p_effective_date BETWEEN ppf.effective_start_date
574: AND ppf.effective_end_date
575: AND ppf.party_id = ppf2.party_id

Line 607: from per_all_people_f per_per

603: RETURN VARCHAR2
604: IS
605: CURSOR csr_is_emp is
606: select 1
607: from per_all_people_f per_per
608: where per_per.party_id=p_party_id
609: and p_eff_date between per_per.effective_start_date and per_per.effective_end_date
610: and per_per.current_employee_flag='Y';
611: --

Line 614: from per_all_people_f per_per

610: and per_per.current_employee_flag='Y';
611: --
612: cursor csr_has_vac is
613: select 1
614: from per_all_people_f per_per
615: ,per_all_assignments_f per_asg
616: ,per_vacancies per_vac
617: where per_per.party_id=p_party_id
618: and p_eff_date between per_per.effective_start_date and per_per.effective_end_date

Line 658: from per_all_people_f per_per

654: RETURN VARCHAR2
655: IS
656: CURSOR csr_is_emp is
657: select 1
658: from per_all_people_f per_per
659: where per_per.person_id=p_person_id
660: and p_eff_date between per_per.effective_start_date and per_per.effective_end_date
661: and (per_per.current_employee_flag='Y' or per_per.current_npw_flag='Y');
662: --

Line 665: from per_all_people_f per_per

661: and (per_per.current_employee_flag='Y' or per_per.current_npw_flag='Y');
662: --
663: CURSOR csr_is_emp2 is
664: select 1
665: from per_all_people_f per_per
666: , per_all_people_f per_per2
667: where per_per.person_id=p_person_id
668: and p_eff_date between per_per.effective_start_date and per_per.effective_end_date
669: and per_per.party_id is not null

Line 666: , per_all_people_f per_per2

662: --
663: CURSOR csr_is_emp2 is
664: select 1
665: from per_all_people_f per_per
666: , per_all_people_f per_per2
667: where per_per.person_id=p_person_id
668: and p_eff_date between per_per.effective_start_date and per_per.effective_end_date
669: and per_per.party_id is not null
670: and per_per2.party_id=per_per.party_id