APPS.PQP_PERASGADD_RIW dependencies on HRDPV_CREATE_EMPLOYEE

Line 1675: from hrdpv_create_employee

1671: substrb(p_national_identifier, 1,
1672: lengthb(p_national_identifier) - 4) = 'XXXXX') then
1673: l_dyn_sql_qry :=
1674: ' select p_national_identifier
1675: from hrdpv_create_employee
1676: where batch_id = ' || p_batch_id ||
1677: ' and link_value = ' || p_data_pump_batch_line_id ||
1678: ' union
1679: select p_national_identifier

Line 7788: -- Cursor to get previous data from hrdpv_create_employee

7784: and link_value = c_link_value;
7785:
7786: l_dp_hire_job_rec hrdpv_hire_into_job%rowtype;
7787:
7788: -- Cursor to get previous data from hrdpv_create_employee
7789: cursor csr_get_create_emp_data (c_batch_id in number
7790: ,c_link_value in number) is
7791: select *
7792: from hrdpv_create_employee

Line 7792: from hrdpv_create_employee

7788: -- Cursor to get previous data from hrdpv_create_employee
7789: cursor csr_get_create_emp_data (c_batch_id in number
7790: ,c_link_value in number) is
7791: select *
7792: from hrdpv_create_employee
7793: where batch_id = c_batch_id
7794: and link_value = c_link_value;
7795:
7796: l_dp_crt_emp_rec hrdpv_create_employee%rowtype;

Line 7796: l_dp_crt_emp_rec hrdpv_create_employee%rowtype;

7792: from hrdpv_create_employee
7793: where batch_id = c_batch_id
7794: and link_value = c_link_value;
7795:
7796: l_dp_crt_emp_rec hrdpv_create_employee%rowtype;
7797:
7798: -- Cursor to get previous data from hrdpv_update_person
7799: cursor csr_get_update_per_data (c_batch_id in number
7800: ,c_link_value in number) is