APPS.PQP_PERASGADD_RIW dependencies on HRDPV_CREATE_EMPLOYEE

Line 1665: from hrdpv_create_employee

1661: substrb(p_national_identifier, 1,
1662: lengthb(p_national_identifier) - 4) = 'XXXXX') then
1663: l_dyn_sql_qry :=
1664: ' select p_national_identifier
1665: from hrdpv_create_employee
1666: where batch_id = ' || p_batch_id ||
1667: ' and link_value = ' || p_data_pump_batch_line_id ||
1668: ' union
1669: select p_national_identifier

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

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
7387: select *
7388: from hrdpv_create_employee

Line 7388: from hrdpv_create_employee

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
7387: select *
7388: from hrdpv_create_employee
7389: where batch_id = c_batch_id
7390: and link_value = c_link_value;
7391:
7392: l_dp_crt_emp_rec hrdpv_create_employee%rowtype;

Line 7392: l_dp_crt_emp_rec hrdpv_create_employee%rowtype;

7388: from hrdpv_create_employee
7389: where batch_id = c_batch_id
7390: and link_value = c_link_value;
7391:
7392: l_dp_crt_emp_rec hrdpv_create_employee%rowtype;
7393:
7394: -- Cursor to get previous data from hrdpv_update_person
7395: cursor csr_get_update_per_data (c_batch_id in number
7396: ,c_link_value in number) is