APPS.PQP_UPDATE_WORK_PATTERN_TABLE dependencies on PAY_USER_TABLES

Line 7: g_table_name pay_user_tables.user_table_name%TYPE

3:
4: g_package_name VARCHAR2(61) := 'pqp_update_work_pattern_table.' ;
5: g_debug BOOLEAN ;
6: g_legislation_code VARCHAR2(30) ;
7: g_table_name pay_user_tables.user_table_name%TYPE
8: :='PQP_COMPANY_WORK_PATTERNS' ;
9: g_row_ids t_row_ids ;
10:
11: -- to cache the row_ids/name of the 3 seeded rows

Line 122: FROM pay_user_tables

118: ,p_legislation_code IN VARCHAR2
119: ,p_business_group_id IN NUMBER )
120: IS
121: SELECT user_table_id
122: FROM pay_user_tables
123: WHERE user_table_name = p_table_name
124: AND ( legislation_code = p_legislation_code
125: OR business_group_id = p_business_group_id ) ;
126:

Line 174: l_user_table_id pay_user_tables.user_table_id%TYPE ;

170: AND puci.user_column_id = p_user_column_id
171: AND puci.user_row_id = p_user_row_id ;
172:
173:
174: l_user_table_id pay_user_tables.user_table_id%TYPE ;
175: l_row_effective_start_date DATE ;
176: l_row_effective_end_date DATE ;
177:
178: l_row_values t_row_values ; --Collection to keep values of 3 rows.

Line 464: ,p_user_table_id IN pay_user_tables.user_table_id%TYPE

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
468: