DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 978: from pay_element_entry_values_f pee

974: ) is
975: select screen_entry_value
976: ,effective_start_date
977: ,effective_end_date
978: from pay_element_entry_values_f pee
979: where pee.element_entry_id = c_element_entry_id
980: and pee.input_value_id = c_input_value_id
981: and (pee.effective_start_date between c_effective_start_date
982: and c_effective_end_date

Line 1006: from pay_element_entry_values_f pee

1002: ) is
1003: select screen_entry_value
1004: ,effective_start_date
1005: ,effective_end_date
1006: from pay_element_entry_values_f pee
1007: where pee.element_entry_id = c_element_entry_id
1008: and pee.input_value_id = c_input_value_id
1009: and pee.effective_start_date = c_effective_start_date
1010: and pee.effective_end_date = c_effective_end_date;