APPS.PQP_GB_OSP_FUNCTIONS dependencies on PER_PEOPLE_EXTRA_INFO

Line 2162: ,per_people_extra_info pei

2158: ,pei_information12 band2
2159: ,pei_information13 band3
2160: ,pei_information14 band4
2161: FROM per_all_assignments_f asg
2162: ,per_people_extra_info pei
2163: WHERE asg.assignment_id = p_assignment_id -- index primary key
2164: AND p_effective_date
2165: BETWEEN asg.effective_start_date
2166: AND asg.effective_end_date

Line 2167: AND pei.person_id = asg.person_id -- index PER_PEOPLE_EXTRA_INFO_N50

2163: WHERE asg.assignment_id = p_assignment_id -- index primary key
2164: AND p_effective_date
2165: BETWEEN asg.effective_start_date
2166: AND asg.effective_end_date
2167: AND pei.person_id = asg.person_id -- index PER_PEOPLE_EXTRA_INFO_N50
2168: AND pei.information_type = 'PQP_GB_GAP_ENTITLEMENT_INFO'
2169: AND pei.pei_information3 = p_pl_id_txt;
2170:
2171: l_override_entitlement csr_override_entitlement%ROWTYPE;

Line 2175: l_pl_id_txt per_people_extra_info.pei_information3%TYPE;

2171: l_override_entitlement csr_override_entitlement%ROWTYPE;
2172:
2173: l_override_entitlement_found BOOLEAN:= FALSE;
2174:
2175: l_pl_id_txt per_people_extra_info.pei_information3%TYPE;
2176:
2177: l_band_entitlements pqp_absval_pkg.t_entitlements;
2178:
2179: i BINARY_INTEGER:= 0;

Line 7965: FROM per_people_extra_info pei

7961: ) IS
7962: SELECT pei_information1 override_start_date_txt
7963: ,pei_information2 override_end_date_txt
7964: ,pei_information3 pl_id_txt
7965: FROM per_people_extra_info pei
7966: WHERE pei.person_id = p_person_id
7967: AND pei.information_type = p_information_type
7968: AND pei.pei_information3 = p_pei_information3 -- fetch rows of same plan
7969: AND pei.person_extra_info_id <> p_person_extra_info_id;