DBA Data[Home] [Help]

APPS.PAY_FR_PTO_PKG dependencies on PER_SHARED_TYPES

Line 3841: ( SELECT pst.INFORMATION3 from per_shared_types pst

3837: and p.current_employee_flag = 'Y'
3838: and p.sex = 'F'
3839: and nvl(pcr.date_end, P_child_age_date) >= P_child_age_date
3840: AND EXISTS
3841: ( SELECT pst.INFORMATION3 from per_shared_types pst
3842: WHERE pcr.contact_type = pst.system_type_cd
3843: AND pst.lookup_type = 'CONTACT'
3844: AND pst.INFORMATION3 = 'Y'
3845: AND ( pst.business_group_id = asg.business_group_id