APPS.PQP_PERASGADD_RIW dependencies on HRDPV_UPDATE_EMP_ASG

Line 7828: -- Cursor to get previous data from hrdpv_update_emp_asg

7824: and link_value = c_link_value;
7825:
7826: l_dp_crt_add_rec hrdpv_create_person_address%rowtype;
7827:
7828: -- Cursor to get previous data from hrdpv_update_emp_asg
7829: cursor csr_get_upd_asg_data (c_batch_id in number
7830: ,c_link_value in number) is
7831: select *
7832: from hrdpv_update_emp_asg

Line 7832: from hrdpv_update_emp_asg

7828: -- Cursor to get previous data from hrdpv_update_emp_asg
7829: cursor csr_get_upd_asg_data (c_batch_id in number
7830: ,c_link_value in number) is
7831: select *
7832: from hrdpv_update_emp_asg
7833: where batch_id = c_batch_id
7834: and link_value = c_link_value;
7835:
7836: l_dp_upd_asg_rec hrdpv_update_emp_asg%rowtype;

Line 7836: l_dp_upd_asg_rec hrdpv_update_emp_asg%rowtype;

7832: from hrdpv_update_emp_asg
7833: where batch_id = c_batch_id
7834: and link_value = c_link_value;
7835:
7836: l_dp_upd_asg_rec hrdpv_update_emp_asg%rowtype;
7837:
7838: -- Cursor to get previous data from hrdpv_update_emp_asg_criteria
7839: cursor csr_get_upd_asg_crt_data (c_batch_id in number
7840: ,c_link_value in number) is

Line 7838: -- Cursor to get previous data from hrdpv_update_emp_asg_criteria

7834: and link_value = c_link_value;
7835:
7836: l_dp_upd_asg_rec hrdpv_update_emp_asg%rowtype;
7837:
7838: -- Cursor to get previous data from hrdpv_update_emp_asg_criteria
7839: cursor csr_get_upd_asg_crt_data (c_batch_id in number
7840: ,c_link_value in number) is
7841: select *
7842: from hrdpv_update_emp_asg_criteria

Line 7842: from hrdpv_update_emp_asg_criteria

7838: -- Cursor to get previous data from hrdpv_update_emp_asg_criteria
7839: cursor csr_get_upd_asg_crt_data (c_batch_id in number
7840: ,c_link_value in number) is
7841: select *
7842: from hrdpv_update_emp_asg_criteria
7843: where batch_id = c_batch_id
7844: and link_value = c_link_value;
7845:
7846: l_dp_upd_asg_crt_rec hrdpv_update_emp_asg_criteria%rowtype;

Line 7846: l_dp_upd_asg_crt_rec hrdpv_update_emp_asg_criteria%rowtype;

7842: from hrdpv_update_emp_asg_criteria
7843: where batch_id = c_batch_id
7844: and link_value = c_link_value;
7845:
7846: l_dp_upd_asg_crt_rec hrdpv_update_emp_asg_criteria%rowtype;
7847:
7848: -- Cursor to get previous data from hrdpv_create_contact
7849: cursor csr_get_create_cnt_data (c_batch_id in number
7850: ,c_link_value in number) is