DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on PER_PERSON_TYPES

Line 449: from per_person_types

445: and effective_end_date
446: and ler_id = p_val;
447:
448: cursor c10 is select user_person_type
449: from per_person_types
450: where nvl(business_group_id,nvl(p_business_group_id,-1))
451: = nvl(p_business_group_id,-1)
452: and active_flag = 'Y'
453: and person_type_id = p_val;

Line 1212: from per_person_types

1208: and effective_end_date
1209: and name = p_meaning;
1210:
1211: cursor c10 is select person_type_id
1212: from per_person_types
1213: where nvl(business_group_id,nvl(p_business_group_id,-1))
1214: = nvl(p_business_group_id,-1)
1215: and active_flag = 'Y'
1216: and user_person_type = p_meaning;