APPS.PQP_HROSS_INTEGRATION dependencies on HRDPV_CREATE_EMPLOYEE

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

3841: AND link_value = c_link_value;
3842:
3843: l_dp_hire_job_rec hrdpv_hire_into_job%ROWTYPE;
3844:
3845: -- Cursor to get previous data from hrdpv_create_employee
3846: CURSOR csr_get_create_emp_data (c_batch_id IN Number
3847: ,c_link_value IN Number) IS
3848: SELECT *
3849: FROM hrdpv_create_employee

Line 3849: FROM hrdpv_create_employee

3845: -- Cursor to get previous data from hrdpv_create_employee
3846: CURSOR csr_get_create_emp_data (c_batch_id IN Number
3847: ,c_link_value IN Number) IS
3848: SELECT *
3849: FROM hrdpv_create_employee
3850: WHERE batch_id = c_batch_id
3851: AND link_value = c_link_value;
3852:
3853: l_dp_crt_emp_rec hrdpv_create_employee%ROWTYPE;

Line 3853: l_dp_crt_emp_rec hrdpv_create_employee%ROWTYPE;

3849: FROM hrdpv_create_employee
3850: WHERE batch_id = c_batch_id
3851: AND link_value = c_link_value;
3852:
3853: l_dp_crt_emp_rec hrdpv_create_employee%ROWTYPE;
3854:
3855: -- Cursor to get previous data from hrdpv_update_person
3856: CURSOR csr_get_update_per_data (c_batch_id IN Number
3857: ,c_link_value IN Number) IS

Line 5680: ' FROM hrdpv_create_employee ' ||

5676: SUBSTRB(p_national_identifier,
5677: LENGTHB(p_national_identifier) - 3, 4) || '''';
5678: ELSE
5679: l_dyn_sql_qry := 'SELECT p_national_identifier ' ||
5680: ' FROM hrdpv_create_employee ' ||
5681: ' WHERE batch_id = ' || p_batch_id ||
5682: ' AND link_value = ' || p_data_pump_batch_line_id ||
5683: ' UNION SELECT p_national_identifier ' ||
5684: ' FROM hrdpv_update_person ' ||