DBA Data[Home] [Help]

APPS.PER_KR_CONTACT_RULES dependencies on PER_CONTACT_EXTRA_INFO_F

Line 16: from per_contact_extra_info_f cei

12: is
13:
14: cursor csr_check_contact_details is
15: select count(contact_extra_info_id)
16: from per_contact_extra_info_f cei
17: where cei.contact_relationship_id = P_CONTACT_RELATIONSHIP_ID
18: and cei.information_type = P_INFORMATION_TYPE
19: and to_char(P_EFFECTIVE_START_DATE,'yyyy') = to_char(cei.effective_start_date,'yyyy');
20: begin