DBA Data[Home] [Help]

APPS.PQP_RATES_HISTORY_CALC dependencies on PAY_ELEMENT_LINKS_F

Line 57: ,pay_element_links_f lnk

53: ) IS
54: SELECT eev.screen_entry_value
55: ,liv.default_value
56: FROM pay_element_entries_f ele
57: ,pay_element_links_f lnk
58: ,pay_link_input_values_f liv
59: ,pay_element_entry_values_f eev
60: WHERE ele.assignment_id = p_assignment_id
61: AND ele.entry_type = 'E'

Line 89: FROM pay_element_links_f pel

85: ,p_element_type_id IN NUMBER
86: ,p_effective_date IN DATE
87: ) IS
88: SELECT pee.element_entry_id
89: FROM pay_element_links_f pel
90: ,pay_element_entries_f pee
91: WHERE pel.element_type_id = p_element_type_id
92: AND p_effective_date
93: BETWEEN pel.effective_start_date

Line 113: ,pay_element_links_f lnk

109: ) IS
110: SELECT eev.screen_entry_value
111: ,liv.default_value
112: FROM pay_element_entries_f ele
113: ,pay_element_links_f lnk
114: ,pay_link_input_values_f liv
115: ,pay_element_entry_values_f eev
116: WHERE ele.element_entry_id = p_element_entry_id
117: AND p_effective_date