APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on PER_ALL_PEOPLE_F

Line 1360: from per_all_people_f ppf,

1356: return number is
1357: --
1358: cursor c_per is
1359: select ppf.person_id
1360: from per_all_people_f ppf,
1361: per_contact_relationships pcr
1362: where pcr.contact_person_id = p_dpnt_person_id
1363: and pcr.business_group_id = g_parm.business_group_id
1364: and ppf.person_id = pcr.person_id

Line 1429: from per_all_people_f ppf, per_person_types ppt

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

Line 1567: from per_all_people_f ppf, per_person_types ppt

1563: procedure check_business_rules is
1564: --
1565: cursor c1 is
1566: select null
1567: from per_all_people_f ppf, per_person_types ppt
1568: where ppf.person_id = g_parm.person_id
1569: and ppf.person_type_id = g_parm.person_type_id
1570: and ppf.business_group_id = g_parm.business_group_id
1571: and g_parm.effective_date between ppf.effective_start_date

Line 1937: from per_all_people_f ppf

1933: -- age boundary.
1934: --
1935: cursor c_person is
1936: select ppf.date_of_birth
1937: from per_all_people_f ppf
1938: where ppf.person_id = p_person_id
1939: and ppf.business_group_id = g_parm.business_group_id
1940: and g_parm.effective_date between ppf.effective_start_date
1941: and ppf.effective_end_date;

Line 3672: from per_all_people_f ppf,

3668: procedure create_actnrmdr_ranges is
3669: --
3670: cursor c_per_actnrmdr is
3671: select distinct ppf.person_id
3672: from per_all_people_f ppf,
3673: ben_prtt_enrt_rslt_f pen,
3674: ben_per_in_ler pil,
3675: ben_prtt_enrt_actn_f pea
3676: where (g_parm.person_id is null or

Line 4159: from per_all_people_f ppf

4155: -- this is error condition
4156:
4157: cursor c_per_mssmlg_elig_pgm is
4158: select person_id
4159: from per_all_people_f ppf
4160: where (g_parm.person_id is null or
4161: ppf.person_id = g_parm.person_id)
4162: and g_parm.effective_date between ppf.effective_start_date
4163: and ppf.effective_end_date

Line 4241: from per_all_people_f ppf

4237: );
4238: --
4239: cursor c_per_mssmlg_elig_plnip is
4240: select person_id
4241: from per_all_people_f ppf
4242: where (g_parm.person_id is null or
4243: ppf.person_id = g_parm.person_id)
4244: and g_parm.effective_date between ppf.effective_start_date
4245: and ppf.effective_end_date

Line 4324: from per_all_people_f ppf

4320: );
4321: --
4322: cursor c_per_mssmlg_enrol_pgm is
4323: select person_id
4324: from per_all_people_f ppf
4325: where (g_parm.person_id is null or ppf.person_id = g_parm.person_id)
4326: and g_parm.effective_date between ppf.effective_start_date and ppf.effective_end_date
4327: and ppf.business_group_id = g_parm.business_group_id
4328: and (g_parm.person_type_id is null

Line 4397: from per_all_people_f ppf

4393: );
4394: --
4395: cursor c_per_mssmlg_enrol_plnip is
4396: select person_id
4397: from per_all_people_f ppf
4398: where (g_parm.person_id is null or ppf.person_id = g_parm.person_id)
4399: and g_parm.effective_date between ppf.effective_start_date and ppf.effective_end_date
4400: and ppf.business_group_id = g_parm.business_group_id
4401: and (g_parm.person_type_id is null

Line 4467: from per_all_people_f ppf

4463: );
4464: --
4465: cursor c_per_mssmlg is
4466: select person_id
4467: from per_all_people_f ppf
4468: where (g_parm.person_id is null or ppf.person_id = g_parm.person_id)
4469: and g_parm.effective_date between ppf.effective_start_date and ppf.effective_end_date
4470: and ppf.business_group_id = g_parm.business_group_id
4471: and (g_parm.person_type_id is null