DBA Data[Home] [Help]

APPS.PAY_SE_WAGES_SALARIES dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 434: ,pay_element_entry_values_f eev1

430: ,pay_element_types_f et
431: ,pay_input_values_f iv1
432: ,pay_input_values_f iv2
433: ,pay_element_entries_f ee
434: ,pay_element_entry_values_f eev1
435: ,pay_element_entry_values_f eev2
436: WHERE asg1.assignment_id = csr_v_assignment_id
437: AND csr_v_end_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
438: AND csr_v_end_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 435: ,pay_element_entry_values_f eev2

431: ,pay_input_values_f iv1
432: ,pay_input_values_f iv2
433: ,pay_element_entries_f ee
434: ,pay_element_entry_values_f eev1
435: ,pay_element_entry_values_f eev2
436: WHERE asg1.assignment_id = csr_v_assignment_id
437: AND csr_v_end_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
438: AND csr_v_end_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
439: AND per.person_id = asg1.person_id

Line 971: ,pay_element_entry_values_f eev1

967: ,pay_element_types_f et
968: ,pay_input_values_f iv1
969: ,pay_input_values_f iv2
970: ,pay_element_entries_f ee
971: ,pay_element_entry_values_f eev1
972: ,pay_element_entry_values_f eev2
973: WHERE asg1.assignment_id = csr_v_assignment_id
974: AND csr_v_end_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
975: AND csr_v_end_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 972: ,pay_element_entry_values_f eev2

968: ,pay_input_values_f iv1
969: ,pay_input_values_f iv2
970: ,pay_element_entries_f ee
971: ,pay_element_entry_values_f eev1
972: ,pay_element_entry_values_f eev2
973: WHERE asg1.assignment_id = csr_v_assignment_id
974: AND csr_v_end_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
975: AND csr_v_end_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
976: AND per.person_id = asg1.person_id