APPS.PER_KR_EXTRA_AEI_RULES dependencies on PER_CONTACT_EXTRA_INFO_F

Line 160: from per_contact_extra_info_f cei

156: cei.cei_information24, -- Bug 14219478
157: cei.object_version_number,
158: cei.effective_start_date,
159: cei.effective_end_date
160: from per_contact_extra_info_f cei
161: where cei.contact_relationship_id = p_cont_rel_id
162: and cei.information_type = 'KR_DPNT_EXPENSE_INFO'
163: and to_char(cei.effective_start_date, 'YYYY') = to_char(p_effective_date,'YYYY');
164: --

Line 439: from per_contact_extra_info_f cei

435: cei.cei_information24, -- Bug 14219478
436: cei.object_version_number,
437: cei.effective_start_date,
438: cei.effective_end_date
439: from per_contact_extra_info_f cei
440: where cei.contact_relationship_id = p_cont_rel_id
441: and cei.information_type = 'KR_DPNT_EXPENSE_INFO'
442: and to_char(cei.effective_start_date, 'YYYY') = to_char(p_effective_date,'YYYY');
443: --

Line 782: from per_contact_extra_info_f cei

778: cei.cei_information24, -- Bug 14219478
779: cei.object_version_number,
780: cei.effective_start_date,
781: cei.effective_end_date
782: from per_contact_extra_info_f cei
783: where cei.contact_relationship_id = p_cont_rel_id
784: and cei.information_type = 'KR_DPNT_EXPENSE_INFO'
785: and to_char(cei.effective_start_date, 'YYYY') = to_char(p_effective_date,'YYYY');
786: --

Line 1052: from per_contact_extra_info_f cei

1048: cei.cei_information24, -- Bug 14219478
1049: cei.object_version_number,
1050: cei.effective_start_date,
1051: cei.effective_end_date
1052: from per_contact_extra_info_f cei
1053: where cei.contact_relationship_id = p_cont_rel_id
1054: and cei.information_type = 'KR_DPNT_EXPENSE_INFO'
1055: and to_char(cei.effective_start_date, 'YYYY') = to_char(p_effective_date,'YYYY');
1056: --

Line 1378: from per_contact_extra_info_f cei

1374: cei.cei_information24, -- Bug 14219478
1375: cei.object_version_number,
1376: cei.effective_start_date,
1377: cei.effective_end_date
1378: from per_contact_extra_info_f cei
1379: where cei.contact_relationship_id = p_cont_rel_id
1380: and cei.information_type = 'KR_DPNT_EXPENSE_INFO'
1381: and to_char(cei.effective_start_date, 'YYYY') = to_char(p_effective_date,'YYYY');
1382: --

Line 1664: from per_contact_extra_info_f cei

1660: cei.cei_information24, -- Bug 14219478
1661: cei.object_version_number,
1662: cei.effective_start_date,
1663: cei.effective_end_date
1664: from per_contact_extra_info_f cei
1665: where cei.contact_relationship_id = p_cont_rel_id
1666: and cei.information_type = 'KR_DPNT_EXPENSE_INFO'
1667: and to_char(cei.effective_start_date, 'YYYY') = to_char(p_effective_date,'YYYY');
1668: --