7370: and link_value = c_link_value
7371: and line_status in ('U', 'E')
7372: and hpbl.api_module_id = ham.api_module_id;
7373:
7374: -- Cursor to get previous data from hrdpv_hire_into_job
7375: cursor csr_get_hire_job_data (c_batch_id in number
7376: ,c_link_value in number) is
7377: select *
7378: from hrdpv_hire_into_job
7374: -- Cursor to get previous data from hrdpv_hire_into_job
7375: cursor csr_get_hire_job_data (c_batch_id in number
7376: ,c_link_value in number) is
7377: select *
7378: from hrdpv_hire_into_job
7379: where batch_id = c_batch_id
7380: and link_value = c_link_value;
7381:
7382: l_dp_hire_job_rec hrdpv_hire_into_job%rowtype;
7378: from hrdpv_hire_into_job
7379: where batch_id = c_batch_id
7380: and link_value = c_link_value;
7381:
7382: l_dp_hire_job_rec hrdpv_hire_into_job%rowtype;
7383:
7384: -- Cursor to get previous data from hrdpv_create_employee
7385: cursor csr_get_create_emp_data (c_batch_id in number
7386: ,c_link_value in number) is