APPS.PQP_SCHEDULE_CALCULATION_PKG dependencies on PAY_USER_TABLES

Line 17: g_legislation_code pay_user_tables.legislation_code%TYPE := NULL;

13: -- g_udt_name VARCHAR2(50) := 'PQP_COMPANY_WORK_PATTERNS';
14: -- g_default_start_day VARCHAR2(10) := 'sunday';
15: g_days_worked NUMBER;
16:
17: g_legislation_code pay_user_tables.legislation_code%TYPE := NULL;
18:
19: --g_wp_days t_wp_days_type;
20:
21: g_package_name VARCHAR2(31) := 'pqp_schedule_calculation_pkg.' ;

Line 26: g_last_business_group_id pay_user_tables.business_group_id%TYPE;

22: g_debug BOOLEAN := hr_utility.debug_enabled ;
23:
24:
25: -- cache for load_work_pattern_into_cache
26: g_last_business_group_id pay_user_tables.business_group_id%TYPE;
27: g_last_max_effective_start_dt DATE;
28: g_last_min_effective_end_dt DATE;
29: g_last_used_work_pattern pay_user_columns.user_column_name%TYPE;
30: g_asg_work_pattern_start_day_n BINARY_INTEGER;

Line 246: FROM pay_user_tables put,

242: SELECT COUNT(pur.row_low_range_or_name)
243: FROM pay_user_rows_f pur
244: WHERE pur.user_row_id IN
245: (SELECT DISTINCT uci.user_row_id
246: FROM pay_user_tables put,
247: pay_user_columns puc,
248: pay_user_column_instances_f uci
249: WHERE put.user_table_name = g_udt_name
250: AND put.legislation_code = g_legislation_code -- Added on 02/01/2003

Line 1807: FROM pay_user_tables uts

1803: ,p_business_group_id NUMBER
1804: ,p_legislation_code VARCHAR2
1805: ) IS
1806: SELECT ucs.user_column_id
1807: FROM pay_user_tables uts
1808: ,pay_user_columns ucs
1809: WHERE uts.user_table_name = p_user_table_name -- PQP_COMPANY_WORK_PATTERNS
1810: AND uts.business_group_id IS NULL
1811: AND uts.legislation_code = p_legislation_code -- as one table is seeded per legislation