APPS.PAY_US_RULES dependencies on PAY_TIME_DEFINITIONS

Line 2172: FROM pay_time_definitions

2168: p_legislation_code VARCHAR2
2169: )
2170: IS
2171: SELECT time_definition_id
2172: FROM pay_time_definitions
2173: WHERE definition_name = p_time_def_name
2174: AND legislation_code = p_legislation_code
2175: AND business_group_id IS NULL;
2176:

Line 2343: FROM pay_time_definitions

2339:
2340: -- Get time_definition_id corresponding to Overtime Week Id
2341: CURSOR get_time_from_week (cp_otl_recurring_period VARCHAR2) IS
2342: SELECT time_definition_id
2343: FROM pay_time_definitions
2344: WHERE creator_id = cp_otl_recurring_period AND creator_type = 'OTL_W';
2345:
2346: -- Get time definition id defined at payroll level
2347: CURSOR get_payroll_time_definition_id (cp_payroll_id NUMBER

Line 2363: FROM pay_time_definitions

2359: p_legislation_code VARCHAR2
2360: )
2361: IS
2362: SELECT time_definition_id
2363: FROM pay_time_definitions
2364: WHERE definition_name = p_time_def_name
2365: AND legislation_code = p_legislation_code
2366: AND business_group_id IS NULL;
2367:

Line 2394: l_default_time_def_name pay_time_definitions.definition_name%TYPE;

2390: l_payroll_id NUMBER;
2391: l_jobs_us_flsa_code VARCHAR2(150);
2392: no_otl_package_function EXCEPTION;
2393: l_otl_text VARCHAR2(10000);
2394: l_default_time_def_name pay_time_definitions.definition_name%TYPE;
2395: l_legislation_code pay_time_definitions.legislation_code%TYPE;
2396: l_time_definition_id NUMBER;
2397: l_time_def_date DATE;
2398: l_element_name VARCHAR2(80);

Line 2395: l_legislation_code pay_time_definitions.legislation_code%TYPE;

2391: l_jobs_us_flsa_code VARCHAR2(150);
2392: no_otl_package_function EXCEPTION;
2393: l_otl_text VARCHAR2(10000);
2394: l_default_time_def_name pay_time_definitions.definition_name%TYPE;
2395: l_legislation_code pay_time_definitions.legislation_code%TYPE;
2396: l_time_definition_id NUMBER;
2397: l_time_def_date DATE;
2398: l_element_name VARCHAR2(80);
2399: