DBA Data[Home] [Help]

APPS.PAY_P45_PKG2 dependencies on PAY_INPUT_VALUES_F

Line 197: pay_input_values_f iv,

193: max(decode(iv.name,'Tax Previous',screen_entry_value))
194: tax_previous
195: FROM pay_element_entries_f e,
196: pay_element_entry_values_f v,
197: pay_input_values_f iv,
198: pay_element_links_f link
199: WHERE e.assignment_id = c_assignment_id
200: AND link.element_type_id = c_paye_id
201: AND e.element_link_id = link.element_link_id

Line 290: FROM pay_input_values_f

286: WHERE element_name = 'PAYE';
287: --
288: CURSOR csr_input_value(p_ipv_name IN VARCHAR2) IS
289: SELECT input_value_id
290: FROM pay_input_values_f
291: WHERE element_type_id = l_paye_element_id
292: AND name = p_ipv_name;
293: --
294: CURSOR csr_result_value(p_ipv_id IN NUMBER) IS