APPS.PAY_SE_ABSENCE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 147: ,pay_element_entry_values_f eev1

143: ,pay_element_links_f el
144: ,pay_element_types_f et
145: ,pay_input_values_f iv1
146: ,pay_element_entries_f ee
147: ,pay_element_entry_values_f eev1
148: WHERE asg1.assignment_id = l_asg_id
149: AND l_eff_dt BETWEEN asg1.effective_start_date AND asg1.effective_end_date
150: AND l_eff_dt BETWEEN asg2.effective_start_date AND asg2.effective_end_date
151: AND per.person_id = asg1.person_id

Line 445: ,pay_element_entry_values_f eev1

441: ,pay_element_links_f el
442: ,pay_element_types_f et
443: ,pay_input_values_f iv1
444: ,pay_element_entries_f ee
445: ,pay_element_entry_values_f eev1
446: WHERE asg1.assignment_id = p_assignment_id --34040 --l_asg_id
447: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
448: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
449: AND per.person_id = asg1.person_id

Line 724: ,pay_element_entry_values_f eev1

720: ,pay_element_links_f el
721: ,pay_element_types_f et
722: ,pay_input_values_f iv1
723: ,pay_element_entries_f ee
724: ,pay_element_entry_values_f eev1
725: WHERE asg1.assignment_id = p_assignment_id --34040 --l_asg_id
726: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
727: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
728: AND per.person_id = asg1.person_id

Line 759: ,pay_element_entry_values_f eev1

755: ,pay_element_links_f el
756: ,pay_element_types_f et
757: ,pay_input_values_f iv1
758: ,pay_element_entries_f ee
759: ,pay_element_entry_values_f eev1
760: WHERE asg1.assignment_id = l_asg_id
761: AND l_eff_dt BETWEEN asg1.effective_start_date AND asg1.effective_end_date
762: AND l_eff_dt BETWEEN asg2.effective_start_date AND asg2.effective_end_date
763: AND per.person_id = asg1.person_id

Line 907: ,pay_element_entry_values_f peevf1

903: least(fnd_date.canonical_to_date(peevf2.SCREEN_ENTRY_VALUE),csr_v_end_date) date_end
904: FROM per_all_assignments_f paaf
905: ,pay_element_types_f et
906: ,pay_element_entries_f ee
907: ,pay_element_entry_values_f peevf1
908: ,pay_element_entry_values_f peevf2
909: ,pay_input_values_f pivf1
910: ,pay_input_values_f pivf2
911: WHERE paaf.assignment_id = csr_v_assignment_id --38399 --p_assignment_id

Line 908: ,pay_element_entry_values_f peevf2

904: FROM per_all_assignments_f paaf
905: ,pay_element_types_f et
906: ,pay_element_entries_f ee
907: ,pay_element_entry_values_f peevf1
908: ,pay_element_entry_values_f peevf2
909: ,pay_input_values_f pivf1
910: ,pay_input_values_f pivf2
911: WHERE paaf.assignment_id = csr_v_assignment_id --38399 --p_assignment_id
912: AND csr_v_end_date /*p_effective_date*/ BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 3499: ,pay_element_entry_values_f eev1

3495: ,pay_element_links_f el
3496: ,pay_element_types_f et
3497: ,pay_input_values_f iv1
3498: ,pay_element_entries_f ee
3499: ,pay_element_entry_values_f eev1
3500: WHERE asg1.assignment_id = csr_v_assignment_id --34040 --l_asg_id
3501: AND p_payroll_end BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3502: AND p_payroll_end BETWEEN asg2.effective_start_date AND asg2.effective_end_date
3503: AND per.person_id = asg1.person_id

Line 3595: ,pay_element_entry_values_f eev1

3591: ,pay_element_links_f el
3592: ,pay_element_types_f et
3593: ,pay_input_values_f iv1
3594: ,pay_element_entries_f ee
3595: ,pay_element_entry_values_f eev1
3596: WHERE asg1.assignment_id = p_assignment_id --34040 --l_asg_id
3597: AND p_pay_end_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3598: AND p_pay_end_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
3599: AND per.person_id = asg1.person_id