APPS.PQP_PERASGADD_RIW dependencies on HRDPV_UPDATE_PERSON

Line 1670: from hrdpv_update_person

1666: where batch_id = ' || p_batch_id ||
1667: ' and link_value = ' || p_data_pump_batch_line_id ||
1668: ' union
1669: select p_national_identifier
1670: from hrdpv_update_person
1671: where batch_id = ' || p_batch_id ||
1672: ' and link_value = ' || p_data_pump_batch_line_id;
1673:
1674: open csr_get_unmasked_ni for l_dyn_sql_qry;

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

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
7397: select *
7398: from hrdpv_update_person

Line 7398: from hrdpv_update_person

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
7397: select *
7398: from hrdpv_update_person
7399: where batch_id = c_batch_id
7400: and link_value = c_link_value;
7401:
7402: l_dp_upd_per_rec hrdpv_update_person%rowtype;

Line 7402: l_dp_upd_per_rec hrdpv_update_person%rowtype;

7398: from hrdpv_update_person
7399: where batch_id = c_batch_id
7400: and link_value = c_link_value;
7401:
7402: l_dp_upd_per_rec hrdpv_update_person%rowtype;
7403:
7404: -- Cursor to get previous data from hrdpv_update_person_address
7405: cursor csr_get_update_add_data (c_batch_id in number
7406: ,c_link_value in number) is

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

7400: and link_value = c_link_value;
7401:
7402: l_dp_upd_per_rec hrdpv_update_person%rowtype;
7403:
7404: -- Cursor to get previous data from hrdpv_update_person_address
7405: cursor csr_get_update_add_data (c_batch_id in number
7406: ,c_link_value in number) is
7407: select *
7408: from hrdpv_update_person_address

Line 7408: from hrdpv_update_person_address

7404: -- Cursor to get previous data from hrdpv_update_person_address
7405: cursor csr_get_update_add_data (c_batch_id in number
7406: ,c_link_value in number) is
7407: select *
7408: from hrdpv_update_person_address
7409: where batch_id = c_batch_id
7410: and link_value = c_link_value;
7411:
7412: l_dp_upd_add_rec hrdpv_update_person_address%rowtype;

Line 7412: l_dp_upd_add_rec hrdpv_update_person_address%rowtype;

7408: from hrdpv_update_person_address
7409: where batch_id = c_batch_id
7410: and link_value = c_link_value;
7411:
7412: l_dp_upd_add_rec hrdpv_update_person_address%rowtype;
7413:
7414: -- Cursor to get previous data from hrdpv_create_person_address
7415: cursor csr_get_create_add_data (c_batch_id in number
7416: ,c_link_value in number) is