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_NL_PGGM_TEMPLATE dependencies on DUAL

Line 468: FROM dual;

464: AND creator_type = p_creator_type;
465: EXCEPTION WHEN no_data_found THEN
466: SELECT pay_retro_component_usages_s.NEXTVAL
467: INTO l_rc_usage_id
468: FROM dual;
469: --
470: IF g_debug THEN
471: hr_utility.set_location('Insert Retro Comp Usgs '||l_proc_name, 20);
472: END IF;

Line 552: FROM dual;

548:
549: EXCEPTION WHEN no_data_found THEN
550: SELECT pay_element_span_usages_s.NEXTVAL
551: INTO l_es_usage_id
552: FROM dual;
553:
554: IF g_debug THEN
555: hr_utility.set_location('Insert Element Span Usgs '||l_proc_name, 30);
556: END IF;

Line 2030: FROM dual

2026: -- for a particular element_type_id
2027: --
2028: CURSOR c_chk_rr_exist (c_element_type_id IN NUMBER) IS
2029: SELECT 1
2030: FROM dual
2031: WHERE EXISTS ( SELECT 1
2032: FROM pay_run_results prr
2033: WHERE prr.element_type_id = c_element_type_id) ;
2034: