APPS.BEN_CONC_REPORTS dependencies on PER_ALL_PEOPLE_F

Line 357: from per_all_people_f ppf, per_person_types ppt

353: return boolean is
354: --
355: cursor c1 is
356: select 'Y'
357: from per_all_people_f ppf, per_person_types ppt
358: where ppf.person_id = p_person_id
359: and ppf.person_type_id = p_person_type_id
360: and ppf.business_group_id = g_parm.business_group_id
361: and g_parm.effective_date between ppf.effective_start_date

Line 401: from per_all_people_f ppf, per_person_types ppt

397: procedure check_business_rules is
398: --
399: cursor c1 is
400: select null
401: from per_all_people_f ppf, per_person_types ppt
402: where ppf.person_id = g_parm.person_id
403: and ppf.person_type_id = g_parm.person_type_id
404: and ppf.business_group_id = g_parm.business_group_id
405: and g_parm.effective_date between ppf.effective_start_date

Line 1273: l_person_id per_all_people_f.person_id%type;

1269: l_cvg_strt_dt date;
1270: l_cvg_end_dt date;
1271: --
1272: l_request_id number;
1273: l_person_id per_all_people_f.person_id%type;
1274: l_object_version_number ben_benefit_actions.object_version_number%type;
1275: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1276: l_person_action_id ben_person_actions.person_action_id%type;
1277: --