DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_INPUT_VALUES_F

Line 6022: ,pay_input_values_f piv

6018: ,min(decode(piv.name, 'Report Type', rrv.RESULT_VALUE, null)) Retro_type
6019: ,min(decode(piv.name, 'Period', rrv.RESULT_VALUE, null)) Period
6020: FROM pay_run_results prr
6021: ,pay_run_result_values rrv
6022: ,pay_input_values_f piv
6023: ,pay_element_types_f pet
6024: WHERE prr.run_result_id = rrv.run_result_id
6025: AND rrv.input_value_id + 0 = piv.input_value_id
6026: AND piv.element_type_id = pet.element_type_id

Line 6190: ,pay_input_values_f piv

6186: ,c_assignment_id NUMBER
6187: ,c_eff_date DATE) IS
6188: SELECT peev.screen_entry_value
6189: FROM pay_element_types_f pet
6190: ,pay_input_values_f piv
6191: ,pay_element_entries_f peef
6192: ,pay_element_entry_values_f peev
6193: WHERE pet.element_name = c_element_name
6194: AND pet.element_type_id = piv.element_type_id

Line 8477: ,pay_input_values_f piv

8473: ,c_assignment_id NUMBER
8474: ,c_eff_date DATE) IS
8475: SELECT peev.screen_entry_value
8476: FROM pay_element_types_f pet
8477: ,pay_input_values_f piv
8478: ,pay_element_entries_f peef
8479: ,pay_element_entry_values_f peev
8480: WHERE pet.element_name = c_element_name
8481: AND pet.element_type_id = piv.element_type_id