DBA Data[Home] [Help]

APPS.PAY_PSD_BUS dependencies on PER_PERSON_TYPES

Line 389: papf.person_type_id in (select person_type_id from per_person_types

385: where papf.person_id = p_per_or_asg_id and
386: papf.business_group_id = p_business_group_id and
387: p_effective_date between papf.effective_start_date and
388: papf.effective_end_date and
389: papf.person_type_id in (select person_type_id from per_person_types
390: where business_group_id = p_business_group_id
391: and system_person_type in ('EMP','EMP_APL'));
392:
393: cursor csr_asg_id is