DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 987: from pay_element_entry_values_f pee

983: ) is
984: select screen_entry_value
985: ,effective_start_date
986: ,effective_end_date
987: from pay_element_entry_values_f pee
988: where pee.element_entry_id = c_element_entry_id
989: and pee.input_value_id = c_input_value_id
990: and (pee.effective_start_date between c_effective_start_date
991: and c_effective_end_date

Line 1015: from pay_element_entry_values_f pee

1011: ) is
1012: select screen_entry_value
1013: ,effective_start_date
1014: ,effective_end_date
1015: from pay_element_entry_values_f pee
1016: where pee.element_entry_id = c_element_entry_id
1017: and pee.input_value_id = c_input_value_id
1018: and pee.effective_start_date = c_effective_start_date
1019: and pee.effective_end_date = c_effective_end_date;