APPS.PER_JP_DEPENDENT_PKG dependencies on PER_CONTACT_EXTRA_INFO_F

Line 393: SELECT COUNT(contact_relationship_id) FROM per_contact_extra_info_f

389: p_effective_date IN DATE,
390: p_information_type_group IN VARCHAR2) RETURN NUMBER IS
391: --
392: CURSOR cel_extra_info_exist IS
393: SELECT COUNT(contact_relationship_id) FROM per_contact_extra_info_f
394: WHERE contact_relationship_id = p_contact_relationship_id
395: AND information_type LIKE p_information_type_group || '%'
396: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
397: --

Line 551: per_contact_extra_info_f pceif,

547: pceif.program_application_id,
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