APPS.PAY_FI_GENERAL dependencies on PAY_ELEMENT_ENTRIES_F

Line 117: ,pay_element_entries_f ee

113: FROM per_all_assignments_f asg1
114: ,pay_element_links_f el
115: ,pay_element_types_f et
116: ,pay_input_values_f iv1
117: ,pay_element_entries_f ee
118: ,pay_element_entry_values_f eev1
119: , ff_formulas_f ff
120: WHERE asg1.assignment_id = p_assignment_id
121: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 275: ,pay_element_entries_f ee

271: SELECT 1
272: FROM per_all_assignments_f asg
273: ,pay_element_links_f el
274: ,pay_element_types_f et
275: ,pay_element_entries_f ee
276: WHERE asg.assignment_id = p_assignment_id
277: AND et.element_name = p_element_name
278: AND et.legislation_code = 'FI'
279: AND el.business_group_id = asg.business_group_id

Line 330: ,pay_element_entries_f ee

326: FROM per_all_assignments_f asg1
327: ,pay_element_links_f el
328: ,pay_element_types_f et
329: ,pay_input_values_f iv1
330: ,pay_element_entries_f ee
331: ,pay_element_entry_values_f eev1
332: , ff_formulas_f ff
333: WHERE asg1.assignment_id = p_assignment_id
334: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 449: ,pay_element_entries_f ee

445: FROM per_all_assignments_f asg1
446: ,pay_element_links_f el
447: ,pay_element_types_f et
448: ,pay_input_values_f iv1
449: ,pay_element_entries_f ee
450: ,pay_element_entry_values_f eev1
451: WHERE asg1.assignment_id = p_assignment_id
452: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
453: AND et.element_name = 'Holiday Pay Accrual Override'

Line 549: ,pay_element_entries_f ee

545: FROM per_all_assignments_f asg1
546: ,pay_element_links_f el
547: ,pay_element_types_f et
548: ,pay_input_values_f iv1
549: ,pay_element_entries_f ee
550: ,pay_element_entry_values_f eev1
551: WHERE asg1.assignment_id = p_assignment_id
552: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
553: AND et.element_name = 'Holiday Pay Entitlement Override'

Line 694: ,pay_element_entries_f ee

690: ,per_all_people_f per
691: ,pay_element_links_f el
692: ,pay_element_types_f et
693: ,pay_input_values_f iv1
694: ,pay_element_entries_f ee
695: ,pay_element_entry_values_f eev1
696: WHERE asg1.assignment_id = p_assignment_id
697: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
698: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date

Line 782: ,pay_element_entries_f ee

778: ,per_all_people_f per
779: ,pay_element_links_f el
780: ,pay_element_types_f et
781: ,pay_input_values_f iv1
782: ,pay_element_entries_f ee
783: ,pay_element_entry_values_f eev1
784: WHERE asg1.assignment_id = p_assignment_id
785: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
786: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date

Line 907: ,pay_element_entries_f ee

903: FROM per_all_assignments_f asg1
904: ,per_all_people_f per
905: ,pay_element_links_f el
906: ,pay_element_types_f et
907: ,pay_element_entries_f ee
908: WHERE asg1.assignment_id = p_assignment_id
909: AND per.person_id = asg1.person_id
910: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
911: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date

Line 1937: ,pay_element_entries_f ee

1933: FROM per_all_assignments_f asg1
1934: ,pay_element_links_f el
1935: ,pay_element_types_f et
1936: ,pay_input_values_f iv1
1937: ,pay_element_entries_f ee
1938: ,pay_element_entry_values_f eev1
1939: WHERE asg1.assignment_id = p_assignment_id
1940: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
1941: AND et.element_name =p_element_name