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_UPDATE_WORK_PATTERN_TABLE dependencies on PAY_USER_COLUMNS

Line 135: FROM pay_user_columns puc

131: ,p_business_group_id IN NUMBER )
132: IS
133: SELECT puc.user_column_name user_column_name
134: ,puc.user_column_id user_column_id
135: FROM pay_user_columns puc
136: WHERE puc.user_table_id = p_user_table_id
137: AND (puc.business_group_id = p_business_group_id
138: OR puc.legislation_code = g_legislation_code )
139: AND ( puc.user_column_name LIKE p_column_name

Line 463: ,p_user_column_id IN pay_user_columns.user_column_id%TYPE

459:
460: FUNCTION get_avg_working_days_in_week (
461: p_business_group_id IN NUMBER
462: ,p_effective_date IN DATE
463: ,p_user_column_id IN pay_user_columns.user_column_id%TYPE
464: ,p_user_table_id IN pay_user_tables.user_table_id%TYPE
465: ,p_total_days_defined OUT NOCOPY NUMBER
466: ,p_total_working_days_defined OUT NOCOPY NUMBER
467: ) RETURN NUMBER IS