APPS.PQP_PERASGADD_RIW dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 7393: --There is a parent-child relationship between tables hr_pump_batch_line_user_keys and hr_pump_batch_lines

7389:
7390: --$ Update Batch Entry in case Corrections are to be made for a record
7391: if p_batch_link is not null then
7392: --Delete old records in batch lines for this batch id and link value
7393: --There is a parent-child relationship between tables hr_pump_batch_line_user_keys and hr_pump_batch_lines
7394: --w.r.t. batch_line_id
7395: --So, first remove data from hr_pump_batch_line_user_keys and then from hr_pump_batch_lines
7396:
7397: delete from hr_pump_batch_line_user_keys where batch_line_id in (

Line 7395: --So, first remove data from hr_pump_batch_line_user_keys and then from hr_pump_batch_lines

7391: if p_batch_link is not null then
7392: --Delete old records in batch lines for this batch id and link value
7393: --There is a parent-child relationship between tables hr_pump_batch_line_user_keys and hr_pump_batch_lines
7394: --w.r.t. batch_line_id
7395: --So, first remove data from hr_pump_batch_line_user_keys and then from hr_pump_batch_lines
7396:
7397: delete from hr_pump_batch_line_user_keys where batch_line_id in (
7398: select batch_line_id from hr_pump_batch_lines where batch_id = p_batch_id
7399: and link_value = p_batch_link );

Line 7397: delete from hr_pump_batch_line_user_keys where batch_line_id in (

7393: --There is a parent-child relationship between tables hr_pump_batch_line_user_keys and hr_pump_batch_lines
7394: --w.r.t. batch_line_id
7395: --So, first remove data from hr_pump_batch_line_user_keys and then from hr_pump_batch_lines
7396:
7397: delete from hr_pump_batch_line_user_keys where batch_line_id in (
7398: select batch_line_id from hr_pump_batch_lines where batch_id = p_batch_id
7399: and link_value = p_batch_link );
7400:
7401: delete from hr_pump_batch_lines where batch_id = p_batch_id and