DBA Data[Home] [Help]

APPS.PAY_GB_RTI_P60 dependencies on PAY_INPUT_VALUES_F

Line 586: pay_input_values_f pivf

582: fnd_number.canonical_to_number(prrv.result_value),NULL)))
583: tax_previous
584: FROM pay_run_results prr ,
585: pay_run_result_values prrv ,
586: pay_input_values_f pivf
587: WHERE prr.assignment_action_id = p_action_id
588: AND prr.ELEMENT_TYPE_ID = g_paye_element_id
589: AND prrv.run_result_id = prr.run_result_id
590: AND pivf.INPUT_VALUE_ID = prrv.INPUT_VALUE_ID;

Line 603: pay_input_values_f iv,

599: fnd_number.canonical_to_number(screen_entry_value),NULL))
600: tax_previous
601: FROM pay_element_entries_f e,
602: pay_element_entry_values_f v,
603: pay_input_values_f iv,
604: pay_element_links_f link
605: WHERE e.assignment_id = p_asg_id
606: AND link.element_type_id = g_paye_details_id
607: AND e.element_link_id = link.element_link_id

Line 3669: pay_input_values_f pivf

3665: IS
3666: SELECT petf.element_type_id,
3667: input_value_id
3668: FROM pay_element_types_f petf,
3669: pay_input_values_f pivf
3670: WHERE petf.element_name = 'NI'
3671: AND petf.element_type_id = pivf.element_type_id
3672: AND pivf.name = 'Process Type'
3673: AND petf.legislation_code = 'GB'