APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on PER_PERSON_TYPE_USAGES_F

Line 1470: from per_person_type_usages_f ptu,

1466: return boolean is
1467: --
1468: cursor c_dpnt is
1469: select 'Y'
1470: from per_person_type_usages_f ptu,
1471: per_person_types ppt
1472: where ptu.person_id = p_person_id
1473: and ptu.person_type_id = ppt.person_type_id
1474: and ppt.system_person_type = 'DPNT'

Line 1517: from per_person_type_usages_f ptu,

1513: return boolean is
1514: --
1515: cursor c_dpnt is
1516: select 'Y'
1517: from per_person_type_usages_f ptu,
1518: per_person_types ppt
1519: where ptu.person_id = p_person_id
1520: and ptu.person_type_id = ppt.person_type_id
1521: and ppt.system_person_type = 'EMP'

Line 3543: from per_person_type_usages_f ppu

3539: --
3540: and (g_parm.person_type_id is null
3541: or
3542: exists (select null
3543: from per_person_type_usages_f ppu
3544: where pil.person_id = ppu.person_id
3545: and ppu.person_type_id = g_parm.person_type_id
3546: and g_parm.effective_date
3547: between ppu.effective_start_date

Line 3698: from per_person_type_usages_f ppu

3694: --
3695: and (g_parm.person_type_id is null
3696: or
3697: exists (select null
3698: from per_person_type_usages_f ppu
3699: where ppf.person_id = ppu.person_id
3700: and ppu.person_type_id = g_parm.person_type_id
3701: and g_parm.effective_date
3702: between ppu.effective_start_date

Line 3846: from per_person_type_usages_f ppu

3842: and ppf.effective_end_date
3843: and (g_parm.person_type_id is null
3844: or
3845: exists (select null
3846: from per_person_type_usages_f ppu
3847: where ppf.person_id = ppu.person_id
3848: and ppu.person_type_id = g_parm.person_type_id
3849: and g_parm.effective_date
3850: between ppu.effective_start_date

Line 4168: from per_person_type_usages_f ppu

4164: and ppf.business_group_id = g_parm.business_group_id
4165: and (g_parm.person_type_id is null
4166: or
4167: exists (select null
4168: from per_person_type_usages_f ppu
4169: where ppf.person_id = ppu.person_id
4170: and ppu.person_type_id = g_parm.person_type_id
4171: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4172: --

Line 4250: from per_person_type_usages_f ppu

4246: and ppf.business_group_id = g_parm.business_group_id
4247: and (g_parm.person_type_id is null
4248: or
4249: exists (select null
4250: from per_person_type_usages_f ppu
4251: where ppf.person_id = ppu.person_id
4252: and ppu.person_type_id = g_parm.person_type_id
4253: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4254: --

Line 4331: from per_person_type_usages_f ppu

4327: and ppf.business_group_id = g_parm.business_group_id
4328: and (g_parm.person_type_id is null
4329: or
4330: exists (select null
4331: from per_person_type_usages_f ppu
4332: where ppf.person_id = ppu.person_id
4333: and ppu.person_type_id = g_parm.person_type_id
4334: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4335: --

Line 4404: from per_person_type_usages_f ppu

4400: and ppf.business_group_id = g_parm.business_group_id
4401: and (g_parm.person_type_id is null
4402: or
4403: exists (select null
4404: from per_person_type_usages_f ppu
4405: where ppf.person_id = ppu.person_id
4406: and ppu.person_type_id = g_parm.person_type_id
4407: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4408: --

Line 4474: from per_person_type_usages_f ppu

4470: and ppf.business_group_id = g_parm.business_group_id
4471: and (g_parm.person_type_id is null
4472: or
4473: exists (select null
4474: from per_person_type_usages_f ppu
4475: where ppf.person_id = ppu.person_id
4476: and ppu.person_type_id = g_parm.person_type_id
4477: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4478: --