DBA Data[Home] [Help]

APPS.PQP_HROSS_INTEGRATION dependencies on HRDPV_UPDATE_CONTACT_RELATIONS

Line 3915: -- Cursor to get previous data from hrdpv_update_contact_relations

3911: AND link_value = c_link_value;
3912:
3913: l_dp_crt_cnt_rec hrdpv_create_contact%ROWTYPE;
3914:
3915: -- Cursor to get previous data from hrdpv_update_contact_relations
3916: CURSOR csr_get_update_cnt_data (c_batch_id IN Number
3917: ,c_link_value IN Number) IS
3918: SELECT *
3919: FROM hrdpv_update_contact_relations

Line 3919: FROM hrdpv_update_contact_relations

3915: -- Cursor to get previous data from hrdpv_update_contact_relations
3916: CURSOR csr_get_update_cnt_data (c_batch_id IN Number
3917: ,c_link_value IN Number) IS
3918: SELECT *
3919: FROM hrdpv_update_contact_relations
3920: WHERE batch_id = c_batch_id
3921: AND link_value = c_link_value;
3922:
3923: l_dp_upd_cnt_rec hrdpv_update_contact_relations%ROWTYPE;

Line 3923: l_dp_upd_cnt_rec hrdpv_update_contact_relations%ROWTYPE;

3919: FROM hrdpv_update_contact_relations
3920: WHERE batch_id = c_batch_id
3921: AND link_value = c_link_value;
3922:
3923: l_dp_upd_cnt_rec hrdpv_update_contact_relations%ROWTYPE;
3924:
3925: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'HR_DataPumpErr';
3926:
3927: l_dp_mode Varchar2(10);