DBA Data[Home] [Help]

APPS.PER_PL_UPDATE_PERSON dependencies on PER_PERSON_TYPE_USAGES_F

Line 44: select 'Y' from per_person_types ppt, per_person_type_usages_f pptu

40: p_effective_date between papf.effective_start_date and papf.effective_end_date;
41:
42: l_csr_per_value csr_per_value%rowtype;
43: cursor csr_person_type(p_person_type_key char) is
44: select 'Y' from per_person_types ppt, per_person_type_usages_f pptu
45: where ppt.person_type_id = pptu.person_type_id and
46: pptu.person_id = p_person_id and
47: ppt.business_group_id = per_business_group_id and
48: ppt.seeded_person_type_key = p_person_type_key and