APPS.IRC_UTILITIES_PKG dependencies on PER_PERSON_TYPE_USAGES_F

Line 331: ,per_person_type_usages_f ptu

327: IS
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

Line 375: ,per_person_type_usages_f ptu

371: IS
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

Line 429: ,per_person_type_usages_f ptu

425: IS
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

Line 483: ,per_person_type_usages_f ptu

479: IS
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

Line 525: ,per_person_type_usages_f ptu

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