DBA Data[Home] [Help]

APPS.PAY_NZ_HOLIDAYS_2003 dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 119: , pay_element_entry_values_f val

115: select nvl(to_number(val.screen_entry_value),0)
116: from pay_element_entries_f ent
117: , pay_element_types_f el
118: , pay_input_values_f piv
119: , pay_element_entry_values_f val
120: , pay_element_links_f link
121: where ent.assignment_id = p_assignment_id
122: and ent.element_entry_id = val.element_entry_id
123: and p_effective_date between ent.effective_start_date and ent.effective_end_date

Line 146: , pay_element_entry_values_f val

142: select nvl(val.screen_entry_value,'Y')
143: from pay_element_entries_f ent
144: , pay_element_types_f el
145: , pay_input_values_f piv
146: , pay_element_entry_values_f val
147: , pay_element_links_f link
148: where ent.assignment_id = p_assignment_id
149: and ent.element_entry_id = val.element_entry_id
150: and p_effective_date between ent.effective_start_date and ent.effective_end_date