APPS.PAY_P45_PKG dependencies on PAY_INPUT_VALUES_F

Line 414: pay_input_values_f piv,

410: SELECT peev.screen_entry_value
411: FROM pay_element_types_f pet,
412: pay_element_links_f pel,
413: pay_element_entries_f pee,
414: pay_input_values_f piv,
415: pay_element_entry_values_f peev
416: WHERE pee.assignment_id = x_assignment_id
417: AND upper(pet.element_name) = 'STUDENT LOAN'
418: AND upper(piv.name) = 'END DATE'

Line 611: FROM pay_input_values_f v,

607: pay_previous,
608: to_number(max(decode(name,'Tax Previous',
609: fnd_number.canonical_to_number(result_value),NULL)))
610: tax_previous
611: FROM pay_input_values_f v,
612: pay_run_result_values rrv
613: WHERE rrv.run_result_id = l_run_result_id
614: AND v.input_value_id = rrv.input_value_id
615: AND v.element_type_id = l_element_type_id;

Line 624: pay_input_values_f iv,

620: max(decode(iv.name,'Pay Previous',screen_entry_value)) pay_previous,
621: max(decode(iv.name,'Tax Previous',screen_entry_value)) tax_previous
622: FROM pay_element_entries_f e,
623: pay_element_entry_values_f v,
624: pay_input_values_f iv,
625: pay_element_links_f link
626: WHERE e.assignment_id = p_assignment_id
627: AND link.element_type_id = g_paye_details_id
628: AND e.element_link_id = link.element_link_id

Line 2007: from pay_input_values_f inv,

2003: cursor csr_tax_code_ni (c_assignment_action_id in number,
2004: c_effective_end_date in date) is
2005: select 1 from dual where exists
2006: (select prrv.result_value
2007: from pay_input_values_f inv,
2008: pay_element_types_f type,
2009: pay_run_results prr,
2010: pay_run_result_values prrv
2011: where prrv.input_value_id = inv.input_value_id

Line 2903: FROM pay_input_values_f

2899: WHERE element_name = 'PAYE';
2900: --
2901: CURSOR csr_input_value(p_ipv_name IN VARCHAR2) IS
2902: SELECT input_value_id
2903: FROM pay_input_values_f
2904: WHERE element_type_id = l_paye_element_id
2905: AND name = p_ipv_name;
2906: --
2907: CURSOR csr_result_value(p_ipv_id IN NUMBER) IS

Line 2954: pay_input_values_f iv,

2950: max(decode(iv.name,'Tax Previous',screen_entry_value))
2951: tax_previous
2952: FROM pay_element_entries_f e,
2953: pay_element_entry_values_f v,
2954: pay_input_values_f iv,
2955: pay_element_links_f link
2956: WHERE e.assignment_id = p_assignment_id
2957: AND link.element_type_id = g_paye_details_id
2958: AND e.element_link_id = link.element_link_id