DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on PER_PERSON_TYPES

Line 396: from per_person_types

392: and effective_end_date
393: and ler_id = p_val;
394:
395: cursor c10 is select user_person_type
396: from per_person_types
397: where nvl(business_group_id,nvl(p_business_group_id,-1))
398: = nvl(p_business_group_id,-1)
399: and active_flag = 'Y'
400: and person_type_id = p_val;

Line 1159: from per_person_types

1155: and effective_end_date
1156: and name = p_meaning;
1157:
1158: cursor c10 is select person_type_id
1159: from per_person_types
1160: where nvl(business_group_id,nvl(p_business_group_id,-1))
1161: = nvl(p_business_group_id,-1)
1162: and active_flag = 'Y'
1163: and user_person_type = p_meaning;