APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on PER_ALL_PEOPLE_F

Line 1356: from per_all_people_f ppf,

1352: return number is
1353: --
1354: cursor c_per is
1355: select ppf.person_id
1356: from per_all_people_f ppf,
1357: per_contact_relationships pcr
1358: where pcr.contact_person_id = p_dpnt_person_id
1359: and pcr.business_group_id = g_parm.business_group_id
1360: and ppf.person_id = pcr.person_id

Line 1425: from per_all_people_f ppf, per_person_types ppt

1421: return boolean is
1422: --
1423: cursor c1 is
1424: select 'Y'
1425: from per_all_people_f ppf, per_person_types ppt
1426: where ppf.person_id = p_person_id
1427: and ppf.person_type_id = p_person_type_id
1428: and ppf.business_group_id = g_parm.business_group_id
1429: and g_parm.effective_date between ppf.effective_start_date

Line 1513: from per_all_people_f ppf, per_person_types ppt

1509: procedure check_business_rules is
1510: --
1511: cursor c1 is
1512: select null
1513: from per_all_people_f ppf, per_person_types ppt
1514: where ppf.person_id = g_parm.person_id
1515: and ppf.person_type_id = g_parm.person_type_id
1516: and ppf.business_group_id = g_parm.business_group_id
1517: and g_parm.effective_date between ppf.effective_start_date

Line 1883: from per_all_people_f ppf

1879: -- age boundary.
1880: --
1881: cursor c_person is
1882: select ppf.date_of_birth
1883: from per_all_people_f ppf
1884: where ppf.person_id = p_person_id
1885: and ppf.business_group_id = g_parm.business_group_id
1886: and g_parm.effective_date between ppf.effective_start_date
1887: and ppf.effective_end_date;

Line 3614: from per_all_people_f ppf,

3610: procedure create_actnrmdr_ranges is
3611: --
3612: cursor c_per_actnrmdr is
3613: select distinct ppf.person_id
3614: from per_all_people_f ppf,
3615: ben_prtt_enrt_rslt_f pen,
3616: ben_per_in_ler pil,
3617: ben_prtt_enrt_actn_f pea
3618: where (g_parm.person_id is null or

Line 4098: from per_all_people_f ppf

4094: -- this is error condition
4095:
4096: cursor c_per_mssmlg_elig_pgm is
4097: select person_id
4098: from per_all_people_f ppf
4099: where (g_parm.person_id is null or
4100: ppf.person_id = g_parm.person_id)
4101: and g_parm.effective_date between ppf.effective_start_date
4102: and ppf.effective_end_date

Line 4180: from per_all_people_f ppf

4176: );
4177: --
4178: cursor c_per_mssmlg_elig_plnip is
4179: select person_id
4180: from per_all_people_f ppf
4181: where (g_parm.person_id is null or
4182: ppf.person_id = g_parm.person_id)
4183: and g_parm.effective_date between ppf.effective_start_date
4184: and ppf.effective_end_date

Line 4263: from per_all_people_f ppf

4259: );
4260: --
4261: cursor c_per_mssmlg_enrol_pgm is
4262: select person_id
4263: from per_all_people_f ppf
4264: where (g_parm.person_id is null or ppf.person_id = g_parm.person_id)
4265: and g_parm.effective_date between ppf.effective_start_date and ppf.effective_end_date
4266: and ppf.business_group_id = g_parm.business_group_id
4267: and (g_parm.person_type_id is null

Line 4332: from per_all_people_f ppf

4328: );
4329: --
4330: cursor c_per_mssmlg_enrol_plnip is
4331: select person_id
4332: from per_all_people_f ppf
4333: where (g_parm.person_id is null or ppf.person_id = g_parm.person_id)
4334: and g_parm.effective_date between ppf.effective_start_date and ppf.effective_end_date
4335: and ppf.business_group_id = g_parm.business_group_id
4336: and (g_parm.person_type_id is null

Line 4402: from per_all_people_f ppf

4398: );
4399: --
4400: cursor c_per_mssmlg is
4401: select person_id
4402: from per_all_people_f ppf
4403: where (g_parm.person_id is null or ppf.person_id = g_parm.person_id)
4404: and g_parm.effective_date between ppf.effective_start_date and ppf.effective_end_date
4405: and ppf.business_group_id = g_parm.business_group_id
4406: and (g_parm.person_type_id is null