DBA Data[Home] [Help]

APPS.PAY_MULTIASG dependencies on PAY_ELEMENT_TYPES_F

Line 105: pay_element_types_f E

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
109: AND INPUTV.element_type_id + 0 = E.element_type_id

Line 174: pay_element_types_f E

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
178: AND INPUTV.element_type_id + 0 = E.element_type_id

Line 207: pay_element_types_f E

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
211: AND INPUTV.element_type_id + 0 = E.element_type_id

Line 240: pay_element_types_f E

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
244: AND INPUTV.element_type_id + 0 = E.element_type_id

Line 283: , pay_element_types_f ETYPE

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
287: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date

Line 323: , pay_element_types_f ETYPE

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
327: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date