DBA Data[Home] [Help]

APPS.PAY_SIMULATOR_PKG dependencies on PAY_INPUT_VALUES_F

Line 512: pay_input_values_f piv

508: IS
509: SELECT DISTINCT
510: piv.element_type_id
511: FROM per_assignment_extra_info pae,
512: pay_input_values_f piv
513: WHERE pae.assignment_id = p_ass_id
514: AND pae.information_type IN (p_sim_region3,p_sim_region4)
515: AND piv.input_value_id = pae.aei_information1
516: ;

Line 524: pay_input_values_f piv

520: SELECT DISTINCT
521: pae.aei_information1 input_value_id,
522: pae.aei_information2 what_if_value
523: FROM per_assignment_extra_info pae,
524: pay_input_values_f piv
525: WHERE pae.assignment_id = p_ass_id
526: AND pae.information_type IN (p_sim_region3,p_sim_region4)
527: AND piv.input_value_id = pae.aei_information1
528: AND piv.element_type_id = p_ele_type_id

Line 901: ,pay_input_values_f piv

897: ,prr.end_date
898: ,prr.element_entry_id
899: ,prv.formula_result_flag
900: FROM pay_element_types_f pet
901: ,pay_input_values_f piv
902: ,pay_run_results prr
903: ,pay_run_result_values prv
904: WHERE prr.assignment_action_id = v_assact_id
905: AND prr.run_result_id = prv.run_result_id