DBA Data[Home] [Help]

APPS.PAY_IP_EMPLOYEE_BALANCES dependencies on PAY_ELEMENT_ENTRIES_F

Line 557: ,pay_element_entries_f ee

553: ,pet.classification_id
554: ,pet.element_information10
555: FROM pay_element_types_f pet
556: ,pay_element_types_f pet2
557: ,pay_element_entries_f ee
558: WHERE pet2.classification_id = l_classification_id
559: AND pet2.element_information10 IS NOT NULL
560: AND ee.effective_end_date >= l_pay_start_date
561: AND ee.effective_start_date <= nvl(l_action_date , p_session_date )

Line 595: ,pay_element_entries_f ee

591: ,pet.element_information11
592: ,pet.element_information13
593: FROM pay_element_types_f pet
594: ,pay_element_types_f pet2
595: ,pay_element_entries_f ee
596: WHERE pet2.classification_id = l_classification_id
597: AND pet2.element_information10 IS NOT NULL
598: AND ee.effective_end_date >= l_pay_start_date
599: AND ee.effective_start_date <= nvl(l_action_date , p_session_date )

Line 672: ,pay_element_entries_f ee

668: ,pet2.element_information10
669: FROM pay_element_classifications ec
670: ,pay_element_types_f et
671: ,pay_element_links_f el
672: ,pay_element_entries_f ee
673: ,pay_element_entry_values_f eev
674: ,pay_balance_feeds_f pbf
675: ,pay_element_types_f pet2
676: ,pay_element_classifications pec

Line 716: ,pay_element_entries_f ee

712: ,pet2.element_information13
713: FROM pay_element_classifications ec
714: ,pay_element_types_f et
715: ,pay_element_links_f el
716: ,pay_element_entries_f ee
717: ,pay_element_entry_values_f eev
718: ,pay_balance_feeds_f pbf
719: ,pay_element_types_f pet2
720: ,pay_element_classifications pec