APPS.PAY_YEAR_END_EXTRACT dependencies on PAY_INPUT_VALUES_F

Line 191: pay_input_values_f

187: and p_effective_date between
188: effective_start_date and effective_end_date;
189: --
190: select input_value_id into g_category_input_id from
191: pay_input_values_f
192: where name = 'Category'
193: and element_type_id = g_ni_id
194: and p_effective_date between
195: effective_start_date and effective_end_date;

Line 198: pay_input_values_f

194: and p_effective_date between
195: effective_start_date and effective_end_date;
196: --
197: select input_value_id into g_scon_input_id from
198: pay_input_values_f
199: where name = 'SCON'
200: and element_type_id = g_ni_id
201: and p_effective_date between
202: effective_start_date and effective_end_date;

Line 786: pay_input_values_f

782: and l_end_year between
783: effective_start_date and effective_end_date;
784: --
785: select input_value_id into l_category_input_id from
786: pay_input_values_f
787: where name = 'Category'
788: and element_type_id = l_ni_id
789: and l_end_year between
790: effective_start_date and effective_end_date;

Line 793: pay_input_values_f

789: and l_end_year between
790: effective_start_date and effective_end_date;
791: --
792: select input_value_id into l_scon_input_id from
793: pay_input_values_f
794: where name = 'SCON'
795: and element_type_id = l_ni_id
796: and l_end_year between
797: effective_start_date and effective_end_date;

Line 1711: pay_input_values_f iv,

1707: SCREEN_ENTRY_VALUE,null))) Tax_previous
1708: from pay_element_entries_f e,
1709: pay_element_entry_values_f v,
1710: pay_gb_year_end_payrolls ye_roll,
1711: pay_input_values_f iv,
1712: pay_element_links_f link
1713: where e.assignment_id = ye_asg.assignment_id
1714: and link.element_type_id = l_paye_details_id
1715: and e.element_link_id = link.element_link_id

Line 1742: from pay_input_values_f v,

1738: (select max(decode(name,'Tax Code',result_value,null)) Tax_code,
1739: max(decode(name,'Tax Basis',result_value,null)) Tax_Basis,
1740: 100 * fnd_number.canonical_to_number(max(decode(name,'Pay Previous',result_value,null))) Pay_previous,
1741: 100 * fnd_number.canonical_to_number(max(decode(name,'Tax Previous',result_value,null))) Tax_previous
1742: from pay_input_values_f v,
1743: pay_run_result_values rrv
1744: where rrv.RUN_RESULT_ID = ye_asg.TAX_RUN_RESULT_ID
1745: and v.INPUT_VALUE_ID = rrv.INPUT_VALUE_ID
1746: and v.element_type_id = l_paye_details_id )

Line 1767: pay_input_values_f iv,

1763: SCREEN_ENTRY_VALUE,null))) Tax_previous
1764: from pay_element_entries_f e,
1765: pay_element_entry_values_f v,
1766: pay_gb_year_end_payrolls ye_roll,
1767: pay_input_values_f iv,
1768: pay_element_links_f link
1769: where e.assignment_id = ye_asg.assignment_id
1770: and link.element_type_id = l_paye_details_id
1771: and e.element_link_id = link.element_link_id