DBA Data[Home] [Help]

APPS.PQP_GB_PSI_STH_HISTORY dependencies on PAY_INPUT_VALUES_F

Line 994: ,pay_input_values_f piv

990: IS
991: SELECT piv.NAME
992: ,peev.screen_entry_value
993: FROM pay_element_entry_values_f peev
994: ,pay_input_values_f piv
995: WHERE peev.element_entry_id = p_element_entry_id
996: AND peev.input_value_id = piv.input_value_id
997: AND UPPER(piv.NAME) IN ('CLAIM DATE','ADJUSTED HOURS')
998: --AND peev.effective_start_date = p_effective_date