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_GB_PSI_FUNCTIONS dependencies on PER_PERIODS_OF_SERVICE

Line 347: from per_all_assignments_f paaf --, per_periods_of_service PPS

343: ,p_effective_date DATE
344: ,p_assignment_id NUMBER
345: ) IS
346: select paaf.*
347: from per_all_assignments_f paaf --, per_periods_of_service PPS
348: where paaf.business_group_id = p_business_group_id
349: and paaf.assignment_id = p_assignment_id
350: and paaf.assignment_type = 'E'
351: -- and pps.person_id = paaf.person_id

Line 369: from per_all_assignments_f paaf, per_periods_of_service PPS

365: ,p_effective_date DATE
366: ,p_assignment_id NUMBER
367: ) IS
368: select paaf.*
369: from per_all_assignments_f paaf, per_periods_of_service PPS
370: where paaf.business_group_id = p_business_group_id
371: and paaf.assignment_id = p_assignment_id
372: and paaf.assignment_type = 'E'
373: and pps.person_id = paaf.person_id

Line 447: from per_all_people_f PER, per_periods_of_service PPS

443: select 'Y'
444: from dual
445: where
446: (select PPS.DATE_START -- DECODE(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,NULL)
447: from per_all_people_f PER, per_periods_of_service PPS
448: where per.person_id = p_person_id
449: and pps.person_id = p_person_id
450: and p_effective_date
451: between per.effective_start_date