APPS.PQP_PERASGADD_RIW dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

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

6985:
6986: --$ Update Batch Entry in case Corrections are to be made for a record
6987: if p_batch_link is not null then
6988: --Delete old records in batch lines for this batch id and link value
6989: --There is a parent-child relationship between tables hr_pump_batch_line_user_keys and hr_pump_batch_lines
6990: --w.r.t. batch_line_id
6991: --So, first remove data from hr_pump_batch_line_user_keys and then from hr_pump_batch_lines
6992:
6993: delete from hr_pump_batch_line_user_keys where batch_line_id in (

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

6987: if p_batch_link is not null then
6988: --Delete old records in batch lines for this batch id and link value
6989: --There is a parent-child relationship between tables hr_pump_batch_line_user_keys and hr_pump_batch_lines
6990: --w.r.t. batch_line_id
6991: --So, first remove data from hr_pump_batch_line_user_keys and then from hr_pump_batch_lines
6992:
6993: delete from hr_pump_batch_line_user_keys where batch_line_id in (
6994: select batch_line_id from hr_pump_batch_lines where batch_id = p_batch_id
6995: and link_value = p_batch_link );

Line 6993: delete from hr_pump_batch_line_user_keys where batch_line_id in (

6989: --There is a parent-child relationship between tables hr_pump_batch_line_user_keys and hr_pump_batch_lines
6990: --w.r.t. batch_line_id
6991: --So, first remove data from hr_pump_batch_line_user_keys and then from hr_pump_batch_lines
6992:
6993: delete from hr_pump_batch_line_user_keys where batch_line_id in (
6994: select batch_line_id from hr_pump_batch_lines where batch_id = p_batch_id
6995: and link_value = p_batch_link );
6996:
6997: delete from hr_pump_batch_lines where batch_id = p_batch_id and