APPS.IRC_PARTY_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 3492: ,per_person_type_usages_f ptu

3488: and asg2.effective_start_date between per2.effective_start_date and per2.effective_end_date
3489: and UPPER(per2.last_name)=UPPER(p_manager_last_name)))
3490: and exists(SELECT 1
3491: FROM per_person_types typ
3492: ,per_person_type_usages_f ptu
3493: WHERE typ.system_person_type = 'EX_EMP'
3494: AND typ.person_type_id = ptu.person_type_id
3495: AND sysdate BETWEEN ptu.effective_start_date
3496: AND ptu.effective_end_date

Line 3571: select 1 from per_person_type_usages_f ptuf

3567: l_person_start_date date;
3568: l_dt_mode varchar2(30);
3569:
3570: cursor ptu_exists(p_person_id number,p_person_type_id number) is
3571: select 1 from per_person_type_usages_f ptuf
3572: where ptuf.person_id=p_person_id
3573: and ptuf.person_type_id=p_person_type_id
3574: and trunc(sysdate) between ptuf.effective_start_date and ptuf.effective_end_date;
3575:

Line 4345: select 1 from per_person_type_usages_f ptuf

4341: where per1.person_id=p_person_id
4342: and trunc(sysdate) between per1.effective_start_date and per1.effective_end_date;
4343: --
4344: cursor ptu_exists(p_person_id number,p_person_type_id number) is
4345: select 1 from per_person_type_usages_f ptuf
4346: where ptuf.person_id=p_person_id
4347: and ptuf.person_type_id=p_person_type_id
4348: and trunc(sysdate) between ptuf.effective_start_date and ptuf.effective_end_date;
4349: --

Line 4704: select 1 from per_person_type_usages_f ptuf

4700: where per1.person_id=p_person_id
4701: and trunc(sysdate) between per1.effective_start_date and per1.effective_end_date;
4702: --
4703: cursor ptu_exists(p_person_id number,p_person_type_id number) is
4704: select 1 from per_person_type_usages_f ptuf
4705: where ptuf.person_id=p_person_id
4706: and ptuf.person_type_id=p_person_type_id
4707: and trunc(sysdate) between ptuf.effective_start_date and ptuf.effective_end_date;
4708: --

Line 5862: from per_person_type_usages_f

5858: and trunc(sysdate) between per.effective_start_date and per.effective_end_date;
5859: --
5860: cursor csr_ptu_details(c_person_id number) is
5861: select person_type_usage_id
5862: from per_person_type_usages_f
5863: where person_id = c_person_id
5864: and trunc(sysdate) between effective_start_date and effective_end_date;
5865: --
5866: -- Variable declarations

Line 5869: l_ptu_id per_person_type_usages_f.person_type_usage_id%type;

5865: --
5866: -- Variable declarations
5867: --
5868: l_s_person_type per_person_types.system_person_type%type;
5869: l_ptu_id per_person_type_usages_f.person_type_usage_id%type;
5870: --
5871: --
5872: begin
5873: --