DBA Data[Home] [Help]

APPS.PQP_NL_ABP_FUNCTIONS dependencies on PAY_ELEMENT_SPAN_USAGES

Line 7265: pay_element_span_usages pesu

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
7269: AND prc.legislation_code = 'NL'

Line 7293: pay_element_span_usages pesu

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
7297: AND (prc.component_name ='Adjustment' OR (prc.component_name ='Correction'