DBA Data[Home] [Help]

APPS.PAY_FI_GENERAL dependencies on PAY_INPUT_VALUES_F

Line 116: ,pay_input_values_f iv1

112: SELECT FF.FORMULA_ID
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

Line 329: ,pay_input_values_f iv1

325: SELECT FF.FORMULA_ID
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

Line 448: ,pay_input_values_f iv1

444: SELECT eev1.SCREEN_ENTRY_VALUE
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

Line 548: ,pay_input_values_f iv1

544: SELECT eev1.SCREEN_ENTRY_VALUE
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

Line 693: ,pay_input_values_f iv1

689: ,per_all_assignments_f asg2
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

Line 781: ,pay_input_values_f iv1

777: ,per_all_assignments_f asg2
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

Line 1936: ,pay_input_values_f iv1

1932: SELECT eev1.SCREEN_ENTRY_VALUE
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