APPS.PQP_PERASGADD_RIW dependencies on HRDPV_UPDATE_PERSON

Line 1680: from hrdpv_update_person

1676: where batch_id = ' || p_batch_id ||
1677: ' and link_value = ' || p_data_pump_batch_line_id ||
1678: ' union
1679: select p_national_identifier
1680: from hrdpv_update_person
1681: where batch_id = ' || p_batch_id ||
1682: ' and link_value = ' || p_data_pump_batch_line_id;
1683:
1684: open csr_get_unmasked_ni for l_dyn_sql_qry;

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

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
7801: select *
7802: from hrdpv_update_person

Line 7802: from hrdpv_update_person

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
7801: select *
7802: from hrdpv_update_person
7803: where batch_id = c_batch_id
7804: and link_value = c_link_value;
7805:
7806: l_dp_upd_per_rec hrdpv_update_person%rowtype;

Line 7806: l_dp_upd_per_rec hrdpv_update_person%rowtype;

7802: from hrdpv_update_person
7803: where batch_id = c_batch_id
7804: and link_value = c_link_value;
7805:
7806: l_dp_upd_per_rec hrdpv_update_person%rowtype;
7807:
7808: -- Cursor to get previous data from hrdpv_update_person_address
7809: cursor csr_get_update_add_data (c_batch_id in number
7810: ,c_link_value in number) is

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

7804: and link_value = c_link_value;
7805:
7806: l_dp_upd_per_rec hrdpv_update_person%rowtype;
7807:
7808: -- Cursor to get previous data from hrdpv_update_person_address
7809: cursor csr_get_update_add_data (c_batch_id in number
7810: ,c_link_value in number) is
7811: select *
7812: from hrdpv_update_person_address

Line 7812: from hrdpv_update_person_address

7808: -- Cursor to get previous data from hrdpv_update_person_address
7809: cursor csr_get_update_add_data (c_batch_id in number
7810: ,c_link_value in number) is
7811: select *
7812: from hrdpv_update_person_address
7813: where batch_id = c_batch_id
7814: and link_value = c_link_value;
7815:
7816: l_dp_upd_add_rec hrdpv_update_person_address%rowtype;

Line 7816: l_dp_upd_add_rec hrdpv_update_person_address%rowtype;

7812: from hrdpv_update_person_address
7813: where batch_id = c_batch_id
7814: and link_value = c_link_value;
7815:
7816: l_dp_upd_add_rec hrdpv_update_person_address%rowtype;
7817:
7818: -- Cursor to get previous data from hrdpv_create_person_address
7819: cursor csr_get_create_add_data (c_batch_id in number
7820: ,c_link_value in number) is