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_UK_UNION_DEDUCTION dependencies on PAY_USER_TABLES

Line 182: ,pay_user_tables tbls

178: -- Recalculation month >= than current month
179: ,TO_CHAR(fnds.effective_date-365,'YYYY') -- use previous year
180: )
181: FROM hr_organization_information hoi
182: ,pay_user_tables tbls
183: ,fnd_sessions fnds
184: WHERE hoi.organization_id = p_union_organization_id
185: AND hoi.org_information_context = g_union_org_info_type
186: AND tbls.user_table_id = TO_NUMBER(hoi.org_information1)

Line 281: ,pay_user_tables tbls

277: ,TO_CHAR(fnds.effective_date-365,'YYYY') -- use previous year
278: )
279: ||'/'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'MM/DD')
280: FROM hr_organization_information hoi
281: ,pay_user_tables tbls
282: ,fnd_sessions fnds
283: WHERE hoi.organization_id = p_union_organization_id
284: AND hoi.org_information_context = g_union_org_info_type
285: AND tbls.user_table_id = TO_NUMBER(hoi.org_information1)

Line 355: ,pay_user_tables tbls

351:
352: CURSOR csr_uk_union_fund_selected IS
353: SELECT NULL
354: FROM pay_user_columns cols
355: ,pay_user_tables tbls
356: WHERE tbls.user_table_name = p_union_rates_table_name
357: AND tbls.user_table_id = cols.user_table_id
358: AND cols.user_column_name = p_union_rates_column_name;
359:

Line 413: ,pay_user_tables tbls

409:
410: CURSOR csr_uk_union_rates_table_row IS
411: SELECT urws.row_low_range_or_name
412: FROM pay_user_rows_f urws
413: ,pay_user_tables tbls
414: ,fnd_sessions fnd
415: WHERE tbls.user_table_name = p_union_rates_table_name
416: AND tbls.range_or_match = 'M'
417: AND urws.user_table_id = tbls.user_table_id