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_PERSON_TYPES

Line 330: FROM per_person_types_tl ttl

326: IS
327: CURSOR csr_emp_person_types
328: IS
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

Line 331: ,per_person_types typ

327: CURSOR csr_emp_person_types
328: IS
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

Line 348: l_user_person_type per_person_types_tl.user_person_type%type;

344: AND p_eff_date BETWEEN ptu.effective_start_date
345: AND ptu.effective_end_date
346: order by typ.system_person_type ASC, ptu.effective_start_date DESC;
347:
348: l_user_person_type per_person_types_tl.user_person_type%type;
349:
350: BEGIN
351: open csr_emp_person_types;
352: fetch csr_emp_person_types into l_user_person_type;

Line 374: FROM per_person_types_tl ttl

370: IS
371: CURSOR csr_emp_person_types
372: IS
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

Line 375: ,per_person_types typ

371: CURSOR csr_emp_person_types
372: IS
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

Line 428: FROM per_person_types_tl ttl

424:
425: CURSOR csr_apl_person_types
426: IS
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

Line 429: ,per_person_types typ

425: CURSOR csr_apl_person_types
426: IS
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

Line 447: l_user_person_type per_person_types_tl.user_person_type%type;

443: AND ptu.effective_end_date
444: ORDER BY typ.system_person_type ASC, ptu.effective_start_date DESC;
445:
446:
447: l_user_person_type per_person_types_tl.user_person_type%type;
448: l_dummy per_person_types_tl.user_person_type%type;
449:
450: BEGIN
451: open csr_emp_person_type_exists;

Line 448: l_dummy per_person_types_tl.user_person_type%type;

444: ORDER BY typ.system_person_type ASC, ptu.effective_start_date DESC;
445:
446:
447: l_user_person_type per_person_types_tl.user_person_type%type;
448: l_dummy per_person_types_tl.user_person_type%type;
449:
450: BEGIN
451: open csr_emp_person_type_exists;
452: fetch csr_emp_person_type_exists into l_dummy;

Line 482: FROM per_person_types_tl ttl

478: IS
479: CURSOR csr_emp_person_types
480: IS
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

Line 483: ,per_person_types typ

479: CURSOR csr_emp_person_types
480: IS
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

Line 497: l_user_person_type per_person_types_tl.user_person_type%type;

493: AND p_eff_date BETWEEN ptu.effective_start_date
494: AND ptu.effective_end_date
495: order by typ.system_person_type ASC, ptu.effective_start_date DESC;
496:
497: l_user_person_type per_person_types_tl.user_person_type%type;
498:
499: BEGIN
500: if (nvl(g_apl_upt_party_id,-1)<>p_party_id) then
501: g_apl_upt_party_id:=p_party_id;

Line 525: FROM per_person_types typ

521: IS
522: CURSOR csr_emp_person_types
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

Line 540: l_system_person_type per_person_types.system_person_type%type;

536: AND p_eff_date BETWEEN ptu.effective_start_date
537: AND ptu.effective_end_date
538: order by typ.system_person_type ASC, ptu.effective_start_date DESC;
539:
540: l_system_person_type per_person_types.system_person_type%type;
541:
542: BEGIN
543: open csr_emp_person_types;
544: fetch csr_emp_person_types into l_system_person_type;

Line 2216: FROM per_person_types typ

2212: --
2213: CURSOR csr_emp_person_types
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

Line 2252: FROM per_person_types typ

2248: CURSOR csr_person_types IS
2249: SELECT typ.system_person_type,
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

Line 2270: FROM per_person_types typ1

2266: WHERE ppf1.party_id = ppf.party_id
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'

Line 2279: l_person_typ per_person_types.system_person_type%type;

2275: AND p_eff_date BETWEEN ppf1.effective_start_date AND ppf1.effective_end_date
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

Line 2318: FROM per_person_types typ

2314: IS
2315: CURSOR csr_person_types IS
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

Line 2333: FROM per_person_types typ1

2329: WHERE ppf1.party_id = ppf.party_id
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'

Line 2342: l_person_typ per_person_types.system_person_type%type;

2338: AND p_eff_date BETWEEN ppf1.effective_start_date AND ppf1.effective_end_date
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: --