[Home] [Help]
1392: return varchar2 is
1393: --
1394: cursor c_person_type is
1395: select ppt.system_person_type
1396: from per_person_types ppt
1397: where ppt.person_type_id = p_person_type_id
1398: and ppt.business_group_id = g_parm.business_group_id;
1399: --
1400: l_type varchar2(30) := null;
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
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'
1475: and g_parm.effective_date between
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'
1522: and g_parm.effective_date between
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
5080: ben_cmbn_age_los_fctr cla,
5081: ben_cm_typ_f cct,
5082: ben_actn_typ actn,
5083: per_people_f ppf,
5084: per_person_types ppt,
5085: ben_pgm_f pgm1,
5086: per_business_groups pbg,
5087: ben_pl_f pln1,
5088: ff_formulas_f ff,