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 )
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 )
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
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