DBA Data[Home] [Help]

APPS.PQP_RATES_HISTORY_CALC dependencies on PAY_ELEMENT_ENTRIES_F

Line 56: FROM pay_element_entries_f ele

52: ,p_effective_date IN DATE
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

Line 90: ,pay_element_entries_f pee

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
94: AND pel.effective_end_date

Line 112: FROM pay_element_entries_f ele

108: ,p_effective_date IN DATE
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