eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_NL_ABP_FUNCTIONS dependencies on PAY_PAYWSMEE_PKG

Line 7259: pay_paywsmee_pkg.get_original_date_earned(pee.element_entry_id) orig_date_earned

7255: p_time_span_id IN NUMBER)
7256: IS
7257: SELECT peev1.screen_entry_value basis,
7258: peev2.screen_entry_value paid,
7259: pay_paywsmee_pkg.get_original_date_earned(pee.element_entry_id) orig_date_earned
7260: FROM pay_element_entry_values_f peev1,
7261: pay_element_entry_values_f peev2,
7262: pay_element_entries_f pee,
7263: pay_retro_component_usages prcu,

Line 7280: AND TO_NUMBER(TO_CHAR(pay_paywsmee_pkg.get_original_date_earned(pee.element_entry_id),'YYYY'))

7276: AND pee.element_entry_id = peev2.element_entry_id
7277: AND peev2.input_value_id = p_iv_id_pv
7278: AND p_date_earned BETWEEN pee.effective_start_date AND pee.effective_end_date
7279: AND p_date_earned BETWEEN peev1.effective_start_date AND peev1.effective_end_date
7280: AND TO_NUMBER(TO_CHAR(pay_paywsmee_pkg.get_original_date_earned(pee.element_entry_id),'YYYY'))
7281: < TO_NUMBER(TO_CHAR(p_date_earned,'YYYY'))
7282: AND p_date_earned BETWEEN peev2.effective_start_date AND peev2.effective_end_date;
7283:
7284: --