APPS.IRC_PARTY_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 3367: ,per_person_type_usages_f ptu

3363: and asg2.effective_start_date between per2.effective_start_date and per2.effective_end_date
3364: and per2.last_name=p_manager_last_name))
3365: and exists(SELECT 1
3366: FROM per_person_types typ
3367: ,per_person_type_usages_f ptu
3368: WHERE typ.system_person_type = 'EX_EMP'
3369: AND typ.person_type_id = ptu.person_type_id
3370: AND sysdate BETWEEN ptu.effective_start_date
3371: AND ptu.effective_end_date

Line 3446: select 1 from per_person_type_usages_f ptuf

3442: l_person_start_date date;
3443: l_dt_mode varchar2(30);
3444:
3445: cursor ptu_exists(p_person_id number,p_person_type_id number) is
3446: select 1 from per_person_type_usages_f ptuf
3447: where ptuf.person_id=p_person_id
3448: and ptuf.person_type_id=p_person_type_id
3449: and trunc(sysdate) between ptuf.effective_start_date and ptuf.effective_end_date;
3450:

Line 4117: select 1 from per_person_type_usages_f ptuf

4113: where per1.person_id=p_person_id
4114: and trunc(sysdate) between per1.effective_start_date and per1.effective_end_date;
4115: --
4116: cursor ptu_exists(p_person_id number,p_person_type_id number) is
4117: select 1 from per_person_type_usages_f ptuf
4118: where ptuf.person_id=p_person_id
4119: and ptuf.person_type_id=p_person_type_id
4120: and trunc(sysdate) between ptuf.effective_start_date and ptuf.effective_end_date;
4121: --

Line 4474: select 1 from per_person_type_usages_f ptuf

4470: where per1.person_id=p_person_id
4471: and trunc(sysdate) between per1.effective_start_date and per1.effective_end_date;
4472: --
4473: cursor ptu_exists(p_person_id number,p_person_type_id number) is
4474: select 1 from per_person_type_usages_f ptuf
4475: where ptuf.person_id=p_person_id
4476: and ptuf.person_type_id=p_person_type_id
4477: and trunc(sysdate) between ptuf.effective_start_date and ptuf.effective_end_date;
4478: --