DBA Data[Home] [Help]

APPS.BEN_CONC_REPORTS dependencies on PER_PERSON_TYPES

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