DBA Data[Home] [Help]

APPS.PAY_FR_MAP_CALC dependencies on PER_SHARED_TYPES

Line 147: ( SELECT pst.INFORMATION3 from per_shared_types pst

143: BETWEEN
144: NVL(pcr.date_start, p_effective_date)
145: AND NVL(pcr.date_end,p_effective_date)
146: AND EXISTS
147: ( SELECT pst.INFORMATION3 from per_shared_types pst
148: WHERE pcr.contact_type = pst.system_type_cd
149: AND pst.lookup_type = 'CONTACT'
150: AND pst.INFORMATION3 = 'Y'
151: AND ( pst.business_group_id = pcr.business_group_id