APPS.PQP_HROSS_INTEGRATION dependencies on HRDPV_UPDATE_PERSON

Line 3855: -- Cursor to get previous data from hrdpv_update_person

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
3858: SELECT *
3859: FROM hrdpv_update_person

Line 3859: FROM hrdpv_update_person

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
3858: SELECT *
3859: FROM hrdpv_update_person
3860: WHERE batch_id = c_batch_id
3861: AND link_value = c_link_value;
3862:
3863: l_dp_upd_per_rec hrdpv_update_person%ROWTYPE;

Line 3863: l_dp_upd_per_rec hrdpv_update_person%ROWTYPE;

3859: FROM hrdpv_update_person
3860: WHERE batch_id = c_batch_id
3861: AND link_value = c_link_value;
3862:
3863: l_dp_upd_per_rec hrdpv_update_person%ROWTYPE;
3864:
3865: -- Cursor to get previous data from hrdpv_update_person_address
3866: CURSOR csr_get_update_add_data (c_batch_id IN Number
3867: ,c_link_value IN Number) IS

Line 3865: -- Cursor to get previous data from hrdpv_update_person_address

3861: AND link_value = c_link_value;
3862:
3863: l_dp_upd_per_rec hrdpv_update_person%ROWTYPE;
3864:
3865: -- Cursor to get previous data from hrdpv_update_person_address
3866: CURSOR csr_get_update_add_data (c_batch_id IN Number
3867: ,c_link_value IN Number) IS
3868: SELECT *
3869: FROM hrdpv_update_person_address

Line 3869: FROM hrdpv_update_person_address

3865: -- Cursor to get previous data from hrdpv_update_person_address
3866: CURSOR csr_get_update_add_data (c_batch_id IN Number
3867: ,c_link_value IN Number) IS
3868: SELECT *
3869: FROM hrdpv_update_person_address
3870: WHERE batch_id = c_batch_id
3871: AND link_value = c_link_value;
3872:
3873: l_dp_upd_add_rec hrdpv_update_person_address%ROWTYPE;

Line 3873: l_dp_upd_add_rec hrdpv_update_person_address%ROWTYPE;

3869: FROM hrdpv_update_person_address
3870: WHERE batch_id = c_batch_id
3871: AND link_value = c_link_value;
3872:
3873: l_dp_upd_add_rec hrdpv_update_person_address%ROWTYPE;
3874:
3875: -- Cursor to get previous data from hrdpv_create_person_address
3876: CURSOR csr_get_create_add_data (c_batch_id IN Number
3877: ,c_link_value IN Number) IS

Line 5684: ' FROM hrdpv_update_person ' ||

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 ' ||
5685: ' WHERE batch_id = ' || p_batch_id ||
5686: ' AND link_value = ' || p_data_pump_batch_line_id;
5687:
5688: END IF;