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 DUAL

Line 397: select 'Y' from dual

393: ,p_assignment_id NUMBER
394: ,p_element_type_id NUMBER
395: )
396: IS
397: select 'Y' from dual
398: where
399: (select pee.element_type_id
400: from pay_element_entries_f pee ,pay_element_links_f pel
401: where pee.element_link_id = pel.element_link_id

Line 444: from dual

440: )
441: IS
442:
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

Line 459: select add_months(p_effective_date,-3) from dual

455: and NVL(pps.final_process_date,to_date('31/12/4712','DD/MM/YYYY'))
456: )
457: <=
458: (
459: select add_months(p_effective_date,-3) from dual
460: );
461:
462: FUNCTION check_debug
463: (p_business_group_id IN VARCHAR2 -- context