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.BEN_DETERMINE_COMMUNICATIONS dependencies on PER_PERSON_TYPE_USAGES_F

Line 1466: from per_person_type_usages_f ptu,

1462: return boolean is
1463: --
1464: cursor c_dpnt is
1465: select 'Y'
1466: from per_person_type_usages_f ptu,
1467: per_person_types ppt
1468: where ptu.person_id = p_person_id
1469: and ptu.person_type_id = ppt.person_type_id
1470: and ppt.system_person_type = 'DPNT'

Line 3485: from per_person_type_usages_f ppu

3481: --
3482: and (g_parm.person_type_id is null
3483: or
3484: exists (select null
3485: from per_person_type_usages_f ppu
3486: where pil.person_id = ppu.person_id
3487: and ppu.person_type_id = g_parm.person_type_id
3488: and g_parm.effective_date
3489: between ppu.effective_start_date

Line 3640: from per_person_type_usages_f ppu

3636: --
3637: and (g_parm.person_type_id is null
3638: or
3639: exists (select null
3640: from per_person_type_usages_f ppu
3641: where ppf.person_id = ppu.person_id
3642: and ppu.person_type_id = g_parm.person_type_id
3643: and g_parm.effective_date
3644: between ppu.effective_start_date

Line 3788: from per_person_type_usages_f ppu

3784: and ppf.effective_end_date
3785: and (g_parm.person_type_id is null
3786: or
3787: exists (select null
3788: from per_person_type_usages_f ppu
3789: where ppf.person_id = ppu.person_id
3790: and ppu.person_type_id = g_parm.person_type_id
3791: and g_parm.effective_date
3792: between ppu.effective_start_date

Line 4107: from per_person_type_usages_f ppu

4103: and ppf.business_group_id = g_parm.business_group_id
4104: and (g_parm.person_type_id is null
4105: or
4106: exists (select null
4107: from per_person_type_usages_f ppu
4108: where ppf.person_id = ppu.person_id
4109: and ppu.person_type_id = g_parm.person_type_id
4110: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4111: --

Line 4189: from per_person_type_usages_f ppu

4185: and ppf.business_group_id = g_parm.business_group_id
4186: and (g_parm.person_type_id is null
4187: or
4188: exists (select null
4189: from per_person_type_usages_f ppu
4190: where ppf.person_id = ppu.person_id
4191: and ppu.person_type_id = g_parm.person_type_id
4192: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4193: --

Line 4270: from per_person_type_usages_f ppu

4266: and ppf.business_group_id = g_parm.business_group_id
4267: and (g_parm.person_type_id is null
4268: or
4269: exists (select null
4270: from per_person_type_usages_f ppu
4271: where ppf.person_id = ppu.person_id
4272: and ppu.person_type_id = g_parm.person_type_id
4273: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4274: --

Line 4339: from per_person_type_usages_f ppu

4335: and ppf.business_group_id = g_parm.business_group_id
4336: and (g_parm.person_type_id is null
4337: or
4338: exists (select null
4339: from per_person_type_usages_f ppu
4340: where ppf.person_id = ppu.person_id
4341: and ppu.person_type_id = g_parm.person_type_id
4342: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4343: --

Line 4409: from per_person_type_usages_f ppu

4405: and ppf.business_group_id = g_parm.business_group_id
4406: and (g_parm.person_type_id is null
4407: or
4408: exists (select null
4409: from per_person_type_usages_f ppu
4410: where ppf.person_id = ppu.person_id
4411: and ppu.person_type_id = g_parm.person_type_id
4412: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4413: --