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
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,