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_GB_T1_PENSION_EXTRACTS dependencies on PAY_DATED_TABLES

Line 3079: FROM pay_dated_tables pdt

3075: AND LEAST(NVL(p_end_date,g_effective_run_date)
3076: ,g_effective_run_date)
3077: AND ppe.surrogate_key = p_element_entry_id
3078: AND EXISTS (SELECT 1
3079: FROM pay_dated_tables pdt
3080: ,pay_event_updates peu
3081: WHERE pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
3082: AND peu.dated_table_id = pdt.dated_table_id
3083: AND peu.change_type = ppe.change_type

Line 3102: FROM pay_dated_tables pdt

3098: ,g_pension_year_start_date)
3099: AND LEAST(NVL(p_end_date,g_effective_run_date)
3100: ,g_effective_run_date)
3101: AND EXISTS (SELECT 1
3102: FROM pay_dated_tables pdt
3103: ,pay_event_updates peu
3104: WHERE pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
3105: AND peu.dated_table_id = pdt.dated_table_id
3106: AND peu.change_type = ppe.change_type

Line 13304: FROM pay_dated_tables pdt

13300: AND ppe.effective_date -- allow all events effective as of and effective p_start_date
13301: BETWEEN p_start_date AND p_end_date
13302: AND ppe.surrogate_key = p_grade_id
13303: AND EXISTS (SELECT 1
13304: FROM pay_dated_tables pdt
13305: ,pay_event_updates peu
13306: WHERE pdt.table_name = 'PAY_GRADE_RULES_F'
13307: AND peu.dated_table_id = pdt.dated_table_id
13308: AND peu.change_type = ppe.change_type