APPS.PAY_US_RULES dependencies on PAY_TIME_DEFINITIONS

Line 2112: FROM pay_time_definitions

2108: p_legislation_code VARCHAR2
2109: )
2110: IS
2111: SELECT time_definition_id
2112: FROM pay_time_definitions
2113: WHERE definition_name = p_time_def_name
2114: AND legislation_code = p_legislation_code
2115: AND business_group_id IS NULL;
2116:

Line 2283: FROM pay_time_definitions

2279:
2280: -- Get time_definition_id corresponding to Overtime Week Id
2281: CURSOR get_time_from_week (cp_otl_recurring_period VARCHAR2) IS
2282: SELECT time_definition_id
2283: FROM pay_time_definitions
2284: WHERE creator_id = cp_otl_recurring_period AND creator_type = 'OTL_W';
2285:
2286: -- Get time definition id defined at payroll level
2287: CURSOR get_payroll_time_definition_id (cp_payroll_id NUMBER

Line 2303: FROM pay_time_definitions

2299: p_legislation_code VARCHAR2
2300: )
2301: IS
2302: SELECT time_definition_id
2303: FROM pay_time_definitions
2304: WHERE definition_name = p_time_def_name
2305: AND legislation_code = p_legislation_code
2306: AND business_group_id IS NULL;
2307:

Line 2334: l_default_time_def_name pay_time_definitions.definition_name%TYPE;

2330: l_payroll_id NUMBER;
2331: l_jobs_us_flsa_code VARCHAR2(150);
2332: no_otl_package_function EXCEPTION;
2333: l_otl_text VARCHAR2(10000);
2334: l_default_time_def_name pay_time_definitions.definition_name%TYPE;
2335: l_legislation_code pay_time_definitions.legislation_code%TYPE;
2336: l_time_definition_id NUMBER;
2337: l_time_def_date DATE;
2338: l_element_name VARCHAR2(80);

Line 2335: l_legislation_code pay_time_definitions.legislation_code%TYPE;

2331: l_jobs_us_flsa_code VARCHAR2(150);
2332: no_otl_package_function EXCEPTION;
2333: l_otl_text VARCHAR2(10000);
2334: l_default_time_def_name pay_time_definitions.definition_name%TYPE;
2335: l_legislation_code pay_time_definitions.legislation_code%TYPE;
2336: l_time_definition_id NUMBER;
2337: l_time_def_date DATE;
2338: l_element_name VARCHAR2(80);
2339: