APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on PER_CONTACT_EXTRA_INFO_F

Line 729: per_contact_extra_info_f cei

725: nvl(cei.cei_information13, 'N')
726: from per_people_f per,
727: per_contact_relationships ctr,
728: per_assignments_f asg,
729: per_contact_extra_info_f cei
730: where asg.assignment_id = p_assignment_id
731: and p_date_earned
732: between asg.effective_start_date and asg.effective_end_date
733: and ctr.person_id = asg.person_id

Line 1127: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106

1123: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1124: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1125: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
1126: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
1127: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
1128: ) return varchar2 is
1129: --
1130: cursor csr_contact_extra_info(p_cont_extra_info_id number) is
1131: select nvl(cei_information1,0) cei_information1,

Line 1143: from per_contact_extra_info_f

1139: nvl(cei_information9,0) cei_information9,
1140: nvl(cei_information10,0) cei_information10,
1141: nvl(cei_information11,0) cei_information11
1142: --
1143: from per_contact_extra_info_f
1144: --
1145: where contact_Extra_info_id = p_cont_extra_info_id;
1146: --
1147: l_cei_record csr_contact_extra_info%rowtype;