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.PAY_USER_TABLE_DETAILS_PKG dependencies on PAY_USER_TABLES

Line 28: FROM pay_user_tables

24:
25: CURSOR chk_table_at_bg
26: IS
27: SELECT user_table_id
28: FROM pay_user_tables
29: WHERE user_table_name = X_USER_TABLE_NAME
30: AND business_group_id IS NOT NULL;
31:
32: l_temp VARCHAR2(1);

Line 133: FROM pay_user_tables

129: SELECT user_table_id
130: ,object_version_number
131: INTO l_user_table_id
132: ,l_object_version_number
133: FROM pay_user_tables
134: WHERE user_table_name = X_USER_TABLE_NAME
135: AND (
136: legislation_code = X_LEGISLATION_CODE
137: OR

Line 184: FROM pay_user_tables

180: ) IS
181: CURSOR c_table_id
182: IS
183: SELECT user_table_id
184: FROM pay_user_tables
185: WHERE user_table_name = X_USER_TABLE_NAME
186: AND (
187: legislation_code = X_LEGISLATION_CODE
188: OR

Line 198: FROM pay_user_tables put,

194: CURSOR c_get_col_instance_id (p_user_row_id NUMBER)
195: IS
196: SELECT val.user_column_instance_id column_instance_id,
197: val.object_version_number object_version_number
198: FROM pay_user_tables put,
199: pay_user_rows_f pur,
200: pay_user_columns puc,
201: pay_user_column_instances_f val
202: WHERE val.user_row_id = pur.user_row_id

Line 375: FROM pay_user_tables

371: ) IS
372: CURSOR c_table_id
373: IS
374: SELECT user_table_id
375: FROM pay_user_tables
376: WHERE user_table_name = X_USER_TABLE_NAME
377: AND (
378: legislation_code = X_LEGISLATION_CODE
379: OR

Line 480: FROM pay_user_tables put,

476: IS
477: SELECT pur.user_row_id,
478: puc.user_column_id,
479: pur.effective_start_date
480: FROM pay_user_tables put,
481: pay_user_rows_f pur,
482: pay_user_columns puc
483: WHERE pur.user_table_id = put.user_table_id
484: AND puc.user_table_id = put.user_table_id

Line 524: FROM pay_user_tables put,

520: l_user_col_instance_id,
521: l_object_version_number,
522: l_effective_start_date,
523: l_effective_end_date
524: FROM pay_user_tables put,
525: pay_user_rows_f pur,
526: pay_user_columns puc,
527: pay_user_column_instances_f val
528: WHERE val.user_row_id = pur.user_row_id