APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on PER_PERSON_TYPES

Line 1392: from per_person_types ppt

1388: return varchar2 is
1389: --
1390: cursor c_person_type is
1391: select ppt.system_person_type
1392: from per_person_types ppt
1393: where ppt.person_type_id = p_person_type_id
1394: and ppt.business_group_id = g_parm.business_group_id;
1395: --
1396: l_type varchar2(30) := null;

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 1467: per_person_types ppt

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'
1471: and g_parm.effective_date between

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 5019: per_person_types ppt,

5015: ben_cmbn_age_los_fctr cla,
5016: ben_cm_typ_f cct,
5017: ben_actn_typ actn,
5018: per_people_f ppf,
5019: per_person_types ppt,
5020: ben_pgm_f pgm1,
5021: per_business_groups pbg,
5022: ben_pl_f pln1,
5023: ff_formulas_f ff,