eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_US_FF_FUNCTIONS dependencies on PER_PEOPLE_EXTRA_INFO

Line 280: FROM per_people_extra_info PEI

276: l_result VARCHAR2(30) := 'FALSE';
277: --+
278: CURSOR c_person IS
279: SELECT 'x'
280: FROM per_people_extra_info PEI
281: WHERE PEI.information_type = 'PER_US_ADDITIONAL_DETAILS'
282: AND PEI.pei_information12 = 'WINDSTAR'
283: AND PEI.person_id = p_person_id;
284: --+

Line 287: FROM per_people_extra_info PEI,

283: AND PEI.person_id = p_person_id;
284: --+
285: CURSOR c_assignment IS
286: SELECT 'x'
287: FROM per_people_extra_info PEI,
288: per_all_assignments_f PAA
289: WHERE PEI.information_type = 'PER_US_ADDITIONAL_DETAILS'
290: AND PEI.pei_information12 = 'WINDSTAR'
291: AND PEI.person_id = PAA.person_id

Line 422: FROM per_people_extra_info pei

418: l_effective_date date;
419: --+
420: CURSOR c_prev_contrib IS
421: SELECT pei.pei_information6
422: FROM per_people_extra_info pei
423: WHERE pei.pei_information7 = to_char(l_effective_date,'YYYY')
424: AND pei.pei_information5 = p_income_code
425: AND pei.information_type = 'PER_US_PAYROLL_DETAILS'
426: AND person_id IN