DBA Data[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on PAY_INPUT_VALUES_F

Line 27: FROM pay_input_values_f inv,

23: SELECT *
24: FROM (SELECT iv_data.*, ROWNUM r
25: FROM (SELECT inv.uom, inv.lookup_type, inv.value_set_id,
26: etp.input_currency_code
27: FROM pay_input_values_f inv,
28: pay_element_types_f etp
29: WHERE inv.element_type_id = p_element_type_id
30: AND etp.element_type_id = p_element_type_id
31: AND p_session_date

Line 99: FROM pay_input_values_f inv,

95: SELECT *
96: FROM (SELECT iv_data.*, ROWNUM r
97: FROM (SELECT inv.uom, inv.lookup_type, inv.value_set_id,
98: etp.input_currency_code
99: FROM pay_input_values_f inv,
100: pay_element_types_f etp
101: WHERE inv.element_type_id = p_element_type_id
102: AND etp.element_type_id = p_element_type_id
103: AND p_session_date