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_ABP_FUNCTIONS dependencies on PAY_RETRO_COMPONENTS

Line 7237: FROM pay_time_definitions s, pay_time_definitions e, pay_time_spans ts, pay_retro_components prc

7233: -- over previous year.
7234: --
7235: CURSOR csr_time_span_id IS
7236: SELECT ts.time_span_id
7237: FROM pay_time_definitions s, pay_time_definitions e, pay_time_spans ts, pay_retro_components prc
7238: WHERE ts.creator_id = prc.retro_component_id
7239: AND prc.component_name ='Correction'
7240: AND prc.legislation_code = 'NL'
7241: AND ts.creator_type = 'RC'

Line 7264: pay_retro_components prc,

7260: FROM pay_element_entry_values_f peev1,
7261: pay_element_entry_values_f peev2,
7262: pay_element_entries_f pee,
7263: pay_retro_component_usages prcu,
7264: pay_retro_components prc,
7265: pay_element_span_usages pesu
7266: WHERE (prc.component_name ='Adjustment' OR (prc.component_name ='Correction'
7267: AND pesu.TIME_SPAN_ID = p_time_span_id) )
7268: AND pee.assignment_id = p_asg_id

Line 7292: pay_retro_components prc,

7288: IS
7289: SELECT piv.element_type_id ele_id, piv.input_value_id iv_id
7290: FROM pay_input_values_f piv,
7291: pay_retro_component_usages prcu,
7292: pay_retro_components prc,
7293: pay_element_span_usages pesu
7294: WHERE prc.legislation_code = 'NL'
7295: AND prcu.retro_component_id = prc.retro_component_id
7296: AND prcu.creator_id = p_element_type_id