DBA Data[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on HR_LOOKUPS

Line 33: g_orcl_tm_app_id_cons CONSTANT hr_lookups.application_id%TYPE := 808;

29: g_batch_ref pay_batch_headers.batch_reference%TYPE
30: DEFAULT NULL;
31: g_batch_name pay_batch_headers.batch_name%TYPE
32: DEFAULT NULL;
33: g_orcl_tm_app_id_cons CONSTANT hr_lookups.application_id%TYPE := 808;
34: g_orcl_hr_app_id_cons CONSTANT hr_lookups.application_id%TYPE := 800;
35:
36: CURSOR g_employee_cur (c_person_id NUMBER, c_date_worked DATE)
37: IS

Line 34: g_orcl_hr_app_id_cons CONSTANT hr_lookups.application_id%TYPE := 800;

30: DEFAULT NULL;
31: g_batch_name pay_batch_headers.batch_name%TYPE
32: DEFAULT NULL;
33: g_orcl_tm_app_id_cons CONSTANT hr_lookups.application_id%TYPE := 808;
34: g_orcl_hr_app_id_cons CONSTANT hr_lookups.application_id%TYPE := 800;
35:
36: CURSOR g_employee_cur (c_person_id NUMBER, c_date_worked DATE)
37: IS
38: SELECT asm.payroll_id, asm.assignment_id, asm.effective_start_date,