DBA Data[Home] [Help]

APPS.PQP_PENSION_EXTRACTS dependencies on PAY_ELEMENT_ENTRIES_F

Line 224: ,pay_element_entries_f pee

220: ,c_input_value_id IN NUMBER) IS
221: SELECT pev.screen_entry_value
222: FROM pay_input_values_f piv
223: ,pay_element_entry_values_f pev
224: ,pay_element_entries_f pee
225: ,pay_element_links_f pel
226: WHERE c_effective_date BETWEEN piv.effective_start_date
227: AND piv.effective_end_date
228: AND c_effective_date BETWEEN pev.effective_start_date

Line 3101: ,pay_element_entries_f pee

3097: SELECT pev.screen_entry_value
3098: ,pee.effective_start_date
3099: FROM pay_input_values_f piv
3100: ,pay_element_entry_values_f pev
3101: ,pay_element_entries_f pee
3102: ,pay_element_links_f pel
3103: WHERE c_effective_date BETWEEN piv.effective_start_date
3104: AND piv.effective_end_date
3105: AND c_effective_date BETWEEN pev.effective_start_date

Line 4088: FROM pay_element_entries_f pee

4084: ,c_business_group_id IN NUMBER
4085: ,c_org_id IN NUMBER) IS
4086:
4087: SELECT 'X'
4088: FROM pay_element_entries_f pee
4089: ,pay_element_links_f pel
4090:
4091: WHERE (c_end_date BETWEEN pee.effective_start_date
4092: AND pee.effective_end_date