DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_BALANCES dependencies on PAY_ELEMENT_ENTRIES_F

Line 171: , pay_element_entries_f ee

167: ,pet.element_information12
168: ,pet.element_information14
169: from pay_element_types_f pet
170: , pay_element_types_f pet2
171: , pay_element_entries_f ee
172: WHERE pet2.classification_id = p_classification_id
173: AND pet2.element_information10 is not null
174: AND ee.effective_end_date >= p_pay_start_date
175: AND ee.effective_start_date <= nvl(p_action_date , p_session_date )

Line 504: ,pay_element_entries_f ee

500: NULL) YTD_VAL
501: from pay_element_classifications ec
502: ,pay_element_types_f et
503: ,pay_element_links_f el
504: ,pay_element_entries_f ee
505: ,pay_element_entry_values_f eev
506: ,pay_balance_feeds_f pbf
507: ,pay_element_types_f pet2
508: ,pay_element_classifications pec