APPS.PER_JP_DEPENDENT_PKG dependencies on PER_CONTACT_INFO_TYPES_VL
Line 552: per_contact_info_types_vl pcitv
548: pceif.program_id,
549: pceif.program_update_date
550: FROM
551: per_contact_extra_info_f pceif, 552: per_contact_info_types_vl pcitv 553: WHERE pceif.contact_relationship_id = p_contact_relationship_id
554: AND pceif.information_type LIKE p_information_type_group || '%'
555: AND p_effective_date BETWEEN pceif.effective_start_date AND pceif.effective_end_date
556: AND pceif.information_type = pcitv.information_type