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 972: ,pay_element_entry_values_f eev1

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

Line 973: ,pay_element_entry_values_f eev2

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