DBA Data[Home] [Help]

APPS.PAY_FI_GENERAL dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 118: ,pay_element_entry_values_f eev1

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
122: AND et.element_name = 'Holiday Pay Information'

Line 331: ,pay_element_entry_values_f eev1

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
335: AND et.element_name = 'Holiday Pay Information'

Line 450: ,pay_element_entry_values_f eev1

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'
454: AND et.legislation_code = 'FI'

Line 550: ,pay_element_entry_values_f eev1

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'
554: AND et.legislation_code = 'FI'

Line 695: ,pay_element_entry_values_f eev1

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
699: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 783: ,pay_element_entry_values_f eev1

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
787: AND per.person_id = asg1.person_id

Line 1938: ,pay_element_entry_values_f eev1

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
1942: AND et.legislation_code = 'FI'