APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on PER_CONTACT_EXTRA_INFO_F

Line 962: per_contact_extra_info_f cei

958: nvl(cei.cei_information13, 'N')
959: from per_people_f per,
960: per_contact_relationships ctr,
961: per_assignments_f asg,
962: per_contact_extra_info_f cei
963: where asg.assignment_id = p_assignment_id
964: and p_date_earned
965: between asg.effective_start_date and asg.effective_end_date
966: and ctr.person_id = asg.person_id

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

1436: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1437: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1438: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
1439: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
1440: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
1441: ) return varchar2 is
1442: --
1443: cursor csr_contact_extra_info(p_cont_extra_info_id number) is
1444: select nvl(cei_information1,0) cei_information1,

Line 1465: from per_contact_extra_info_f

1461: nvl(cei_information22,0) cei_information22, -- Bug 14219478
1462: nvl(cei_information23,0) cei_information23, -- Bug 14219478
1463: nvl(cei_information24,0) cei_information24 -- Bug 14219478
1464: --
1465: from per_contact_extra_info_f
1466: --
1467: where contact_Extra_info_id = p_cont_extra_info_id;
1468: --
1469: l_cei_record csr_contact_extra_info%rowtype;