DBA Data[Home] [Help]

APPS.PAY_MULTIASG dependencies on PER_PAY_BASES

Line 281: , per_pay_bases BASES

277: CURSOR salary_basis_code (p_assign_id NUMBER) IS
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

Line 321: , per_pay_bases BASES

317: CURSOR salary_element (p_assign_id NUMBER) IS
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

Line 349: , per_pay_bases BASES

345: CURSOR asg_salary (p_assign_id NUMBER) IS
346: SELECT fnd_number.canonical_to_number (EEV.screen_entry_value)
347: FROM
348: per_assignments_f ASSIGN
349: , per_pay_bases BASES
350: , pay_element_entries_f EE
351: , pay_element_entry_values_f EEV
352: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
353: AND ASSIGN.effective_end_date