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 p_eff_date BETWEEN ppe.start_date AND NVL(ppe.end_date,HR_GENERAL.end_of_time)

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

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

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

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

Line 202: PER_ALL_PEOPLE_F ppf,

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

Line 203: PER_ALL_PEOPLE_F ppf2

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

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

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

Line 218: PER_ALL_PEOPLE_F ppf,

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

Line 219: PER_ALL_PEOPLE_F ppf2

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

Line 266: PER_ALL_PEOPLE_F ppf

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

Line 278: PER_ALL_PEOPLE_F ppf

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

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

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

Line 333: ,PER_ALL_PEOPLE_F ppf

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

Line 334: ,PER_ALL_PEOPLE_F ppf2

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

Line 377: ,PER_ALL_PEOPLE_F ppf

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

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

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

Line 431: ,PER_ALL_PEOPLE_F ppf

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

Line 432: ,PER_ALL_PEOPLE_F ppf2

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

Line 485: ,PER_ALL_PEOPLE_F ppf

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

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

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

Line 527: ,PER_ALL_PEOPLE_F ppf

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

Line 528: ,PER_ALL_PEOPLE_F ppf2

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

Line 559: (p_person_id IN per_all_people_f.person_id%TYPE

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

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

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

Line 561: RETURN per_all_people_f.person_id%TYPE

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

Line 570: FROM PER_ALL_PEOPLE_F PPF,

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

Line 572: PER_ALL_PEOPLE_F PPF2

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

Line 608: from per_all_people_f per_per

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

Line 615: from per_all_people_f per_per

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

Line 673: from per_all_people_f per_per

669: RETURN VARCHAR2
670: IS
671: CURSOR csr_is_emp is
672: select 1
673: from per_all_people_f per_per
674: where per_per.person_id=p_person_id
675: and p_eff_date between per_per.effective_start_date and per_per.effective_end_date
676: and (per_per.current_employee_flag='Y' or per_per.current_npw_flag='Y');
677: --

Line 680: from per_all_people_f per_per

676: and (per_per.current_employee_flag='Y' or per_per.current_npw_flag='Y');
677: --
678: CURSOR csr_is_emp2 is
679: select 1
680: from per_all_people_f per_per
681: , per_all_people_f per_per2
682: where per_per.person_id=p_person_id
683: and p_eff_date between per_per.effective_start_date and per_per.effective_end_date
684: and per_per.party_id is not null

Line 681: , per_all_people_f per_per2

677: --
678: CURSOR csr_is_emp2 is
679: select 1
680: from per_all_people_f per_per
681: , per_all_people_f per_per2
682: where per_per.person_id=p_person_id
683: and p_eff_date between per_per.effective_start_date and per_per.effective_end_date
684: and per_per.party_id is not null
685: and per_per2.party_id=per_per.party_id

Line 1141: from per_all_people_f

1137: where person_id=l_person_id_appl;
1138: --
1139: Cursor C_Person_id is
1140: select min(person_id)
1141: from per_all_people_f
1142: where party_id in (select party_id
1143: from per_all_people_f
1144: where person_id=l_person_id_appl);
1145: --

Line 1143: from per_all_people_f

1139: Cursor C_Person_id is
1140: select min(person_id)
1141: from per_all_people_f
1142: where party_id in (select party_id
1143: from per_all_people_f
1144: where person_id=l_person_id_appl);
1145: --
1146: Cursor C_Address_details_Rec is
1147: select *

Line 2218: ,PER_ALL_PEOPLE_F ppf

2214: IS
2215: SELECT typ.system_person_type
2216: FROM per_person_types typ
2217: ,per_person_type_usages_f ptu
2218: ,PER_ALL_PEOPLE_F ppf
2219: WHERE ppf.party_id = p_party_id
2220: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
2221: AND ppf.person_id = ptu.person_id
2222: AND typ.system_person_type IN ('EMP','EX_EMP')

Line 2254: ,per_all_people_f ppf

2250: ppf.rehire_recommendation,
2251: hl.Meaning
2252: FROM per_person_types typ
2253: ,per_person_type_usages_f ptu
2254: ,per_all_people_f ppf
2255: ,hr_lookups hl
2256: WHERE ppf.party_id = p_party_id
2257: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
2258: AND ppf.person_id = ptu.person_id

Line 2265: FROM per_all_people_f ppf1

2261: AND p_eff_date BETWEEN ptu.effective_start_date AND ptu.effective_end_date
2262: AND hl.lookup_type = 'IRC_REHIRE_RECOMMENDATION'
2263: AND nvl(ppf.rehire_recommendation,'N') = hl.lookup_code
2264: AND ppf.effective_start_date = (SELECT max(effective_start_date)
2265: FROM per_all_people_f ppf1
2266: WHERE ppf1.party_id = ppf.party_id
2267: AND effective_start_date <= p_eff_date
2268: )
2269: AND NOT EXISTS (SELECT 1

Line 2271: ,per_all_people_f ppf1

2267: AND effective_start_date <= p_eff_date
2268: )
2269: AND NOT EXISTS (SELECT 1
2270: FROM per_person_types typ1
2271: ,per_all_people_f ppf1
2272: WHERE ppf1.party_id = ppf.party_id
2273: AND typ1.person_type_id = ppf1.person_type_id
2274: AND typ1.system_person_type = 'EMP'
2275: AND p_eff_date BETWEEN ppf1.effective_start_date AND ppf1.effective_end_date

Line 2280: l_rehire_recommendation per_all_people_f.rehire_recommendation%type;

2276: )
2277: ORDER BY typ.system_person_type ASC, ptu.effective_start_date DESC;
2278: --
2279: l_person_typ per_person_types.system_person_type%type;
2280: l_rehire_recommendation per_all_people_f.rehire_recommendation%type;
2281: l_rehire_recom_code per_all_people_f.rehire_recommendation%type;
2282: --
2283: BEGIN
2284: --

Line 2281: l_rehire_recom_code per_all_people_f.rehire_recommendation%type;

2277: ORDER BY typ.system_person_type ASC, ptu.effective_start_date DESC;
2278: --
2279: l_person_typ per_person_types.system_person_type%type;
2280: l_rehire_recommendation per_all_people_f.rehire_recommendation%type;
2281: l_rehire_recom_code per_all_people_f.rehire_recommendation%type;
2282: --
2283: BEGIN
2284: --
2285: open csr_person_types;

Line 2320: ,per_all_people_f ppf

2316: SELECT typ.system_person_type,
2317: ppf.rehire_recommendation
2318: FROM per_person_types typ
2319: ,per_person_type_usages_f ptu
2320: ,per_all_people_f ppf
2321: WHERE ppf.party_id = p_party_id
2322: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
2323: AND ppf.person_id = ptu.person_id
2324: AND typ.system_person_type = 'EX_EMP'

Line 2328: FROM per_all_people_f ppf1

2324: AND typ.system_person_type = 'EX_EMP'
2325: AND typ.person_type_id = ptu.person_type_id
2326: AND p_eff_date BETWEEN ptu.effective_start_date AND ptu.effective_end_date
2327: AND ppf.effective_start_date = (SELECT max(effective_start_date)
2328: FROM per_all_people_f ppf1
2329: WHERE ppf1.party_id = ppf.party_id
2330: AND effective_start_date <= p_eff_date
2331: )
2332: AND NOT EXISTS (SELECT 1

Line 2334: ,per_all_people_f ppf1

2330: AND effective_start_date <= p_eff_date
2331: )
2332: AND NOT EXISTS (SELECT 1
2333: FROM per_person_types typ1
2334: ,per_all_people_f ppf1
2335: WHERE ppf1.party_id = ppf.party_id
2336: AND typ1.person_type_id = ppf1.person_type_id
2337: AND typ1.system_person_type = 'EMP'
2338: AND p_eff_date BETWEEN ppf1.effective_start_date AND ppf1.effective_end_date

Line 2343: l_rehire_recommendation per_all_people_f.rehire_recommendation%type;

2339: )
2340: ORDER BY typ.system_person_type ASC, ptu.effective_start_date DESC;
2341: --
2342: l_person_typ per_person_types.system_person_type%type;
2343: l_rehire_recommendation per_all_people_f.rehire_recommendation%type;
2344: --
2345: BEGIN
2346: --
2347: open csr_person_types;

Line 2376: AND phn.parent_table = 'PER_ALL_PEOPLE_F'

2372: SELECT phn.phone_number || nvl2(hlk.meaning, '(' || hlk.meaning || ')', null)
2373: into l_number
2374: FROM per_phones phn, hr_lookups hlk
2375: WHERE phn.parent_id = pPersonIdIn
2376: AND phn.parent_table = 'PER_ALL_PEOPLE_F'
2377: AND trunc(SYSDATE) BETWEEN phn.date_from (+)
2378: AND nvl (phn.date_to , trunc(SYSDATE))
2379: AND phn.validity = hlk.lookup_code (+)
2380: AND hlk.lookup_type (+) = 'IRC_CONTACT_TIMES'

Line 2386: and phn2.parent_table = 'PER_ALL_PEOPLE_F'

2382: and phn.last_update_date = (select max(last_update_date)
2383: from per_phones phn2
2384: where phn.parent_id = phn2.parent_id
2385: and phn2.phone_type = 'M'
2386: and phn2.parent_table = 'PER_ALL_PEOPLE_F'
2387: )
2388: and rownum <2;
2389: return l_number;
2390: exception