APPS.PAY_P45_PKG dependencies on PAY_INPUT_VALUES_F

Line 462: pay_input_values_f piv,

458: SELECT peev.screen_entry_value
459: FROM pay_element_types_f pet,
460: pay_element_links_f pel,
461: pay_element_entries_f pee,
462: pay_input_values_f piv,
463: pay_element_entry_values_f peev
464: WHERE pee.assignment_id = x_assignment_id
465: AND upper(pet.element_name) = 'STUDENT LOAN'
466: AND upper(piv.name) = 'END DATE'

Line 668: FROM pay_input_values_f v,

664: pay_previous,
665: to_number(max(decode(name,'Tax Previous',
666: fnd_number.canonical_to_number(result_value),NULL)))
667: tax_previous
668: FROM pay_input_values_f v,
669: pay_run_result_values rrv
670: WHERE rrv.run_result_id = l_run_result_id
671: AND v.input_value_id = rrv.input_value_id
672: AND v.element_type_id = l_element_type_id;

Line 681: pay_input_values_f iv,

677: max(decode(iv.name,'Pay Previous',screen_entry_value)) pay_previous,
678: max(decode(iv.name,'Tax Previous',screen_entry_value)) tax_previous
679: FROM pay_element_entries_f e,
680: pay_element_entry_values_f v,
681: pay_input_values_f iv,
682: pay_element_links_f link
683: WHERE e.assignment_id = p_assignment_id
684: AND link.element_type_id = g_paye_details_id
685: AND e.element_link_id = link.element_link_id

Line 2129: from pay_input_values_f inv,

2125: cursor csr_tax_code_ni (c_assignment_action_id in number) is
2126: -- c_effective_end_date in date) is --Bug 9036584
2127: select 1 from dual where exists
2128: (select prrv.result_value
2129: from pay_input_values_f inv,
2130: pay_element_types_f type,
2131: pay_run_results prr,
2132: pay_run_result_values prrv
2133: where prrv.input_value_id = inv.input_value_id

Line 3288: FROM pay_input_values_f

3284: WHERE element_name = 'PAYE';
3285: --
3286: CURSOR csr_input_value(p_ipv_name IN VARCHAR2) IS
3287: SELECT input_value_id
3288: FROM pay_input_values_f
3289: WHERE element_type_id = l_paye_element_id
3290: AND name = p_ipv_name;
3291: --
3292: CURSOR csr_result_value(p_ipv_id IN NUMBER) IS

Line 3339: pay_input_values_f iv,

3335: max(decode(iv.name,'Tax Previous',screen_entry_value))
3336: tax_previous
3337: FROM pay_element_entries_f e,
3338: pay_element_entry_values_f v,
3339: pay_input_values_f iv,
3340: pay_element_links_f link
3341: WHERE e.assignment_id = p_assignment_id
3342: AND link.element_type_id = g_paye_details_id
3343: AND e.element_link_id = link.element_link_id