DBA Data[Home] [Help]

APPS.PQP_INI_BAL dependencies on PAY_INPUT_VALUES_F

Line 1016: FROM pay_input_values_f piv

1012: IS
1013: SELECT piv.input_value_id
1014: ,piv.display_sequence
1015: ,piv.name
1016: FROM pay_input_values_f piv
1017: WHERE piv.element_type_id =cp_element_id
1018: AND p_effective_date BETWEEN piv.effective_start_date
1019: AND piv.effective_end_date
1020: ORDER BY piv.display_sequence;

Line 1554: FROM pay_input_values_f piv

1550: SELECT piv.input_value_id
1551: ,piv.name
1552: ,prrv.result_value entry_value
1553: ,piv.display_sequence
1554: FROM pay_input_values_f piv
1555: ,pay_run_result_values prrv
1556: WHERE prrv.run_result_id = cp_run_result_id
1557: AND piv.input_value_id=prrv.input_value_id
1558: AND piv.name IN ('Vehicle Type'