DBA Data[Home] [Help]

APPS.PAY_MULTIASG dependencies on PAY_INPUT_VALUES_F

Line 104: pay_input_values_f INPUTV,

100: FROM
101: pay_element_entry_values_f EEV,
102: pay_element_entries_f EE,
103: pay_link_input_values_f LIV,
104: pay_input_values_f INPUTV,
105: pay_element_types_f E
106:
107: WHERE p_date_earned BETWEEN INPUTV.effective_start_date
108: AND INPUTV.effective_end_date

Line 173: pay_input_values_f INPUTV,

169: FROM
170: pay_element_entry_values_f EEV,
171: pay_element_entries_f EE,
172: pay_link_input_values_f LIV,
173: pay_input_values_f INPUTV,
174: pay_element_types_f E
175:
176: WHERE p_date_earned BETWEEN INPUTV.effective_start_date
177: AND INPUTV.effective_end_date

Line 206: pay_input_values_f INPUTV,

202: FROM
203: pay_element_entry_values_f EEV,
204: pay_element_entries_f EE,
205: pay_link_input_values_f LIV,
206: pay_input_values_f INPUTV,
207: pay_element_types_f E
208:
209: WHERE p_date_earned BETWEEN INPUTV.effective_start_date
210: AND INPUTV.effective_end_date

Line 239: pay_input_values_f INPUTV,

235: FROM
236: pay_element_entry_values_f EEV,
237: pay_element_entries_f EE,
238: pay_link_input_values_f LIV,
239: pay_input_values_f INPUTV,
240: pay_element_types_f E
241:
242: WHERE p_date_earned BETWEEN INPUTV.effective_start_date
243: AND INPUTV.effective_end_date

Line 282: , pay_input_values_f INPUTV

278: SELECT BASES.pay_basis
279: FROM
280: per_assignments_f ASSIGN
281: , per_pay_bases BASES
282: , pay_input_values_f INPUTV
283: , pay_element_types_f ETYPE
284: , pay_rates RATE
285: , hr_lookups HR1
286: , hr_lookups HR2

Line 322: , pay_input_values_f INPUTV

318: SELECT ETYPE.element_name
319: FROM
320: per_assignments_f ASSIGN
321: , per_pay_bases BASES
322: , pay_input_values_f INPUTV
323: , pay_element_types_f ETYPE
324: , pay_rates RATE
325: , hr_lookups HR1
326: , hr_lookups HR2