APPS.HR_DELETE dependencies on PAY_BALANCE_BATCH_LINES

Line 104: pay_balance_batch_lines.

100: Added new procedure delete_location.
101: 70.25 15-oct-95 akelly Removed delete_location.
102: 70.26 17-OCT-95 nbristow Added delete_bal_load_struct to delete
103: from pay_balance_batch_headers and
104: pay_balance_batch_lines.
105: 70.27 31-OCT-95 Kev Koh Enhanced delete_secure_objects with
106: delete cursor
107: 70.28 31-OCT-95 Kev Koh Enhanced delete_secure_objects and
108: delete_bal_load_struct with

Line 185: pay_balance_batch_lines.

181: 70.43 06-OCT-96 D.Kerr Temporarily removed delete_competence_detail
182: during 10.7/Prod15 release phase
183: 70.44 11-NOV-96 N.Bristow Uncommented the deletion from
184: pay_balance_batch_headers and
185: pay_balance_batch_lines.
186: 70.45 18-NOV-96 Tmathers Added p_rt_running parameter to allow
187: Rt's once again to be re-runnable.
188: 70.46 12-MAR-97 DLo 1 Added delete statements to
189: delete_job_direct to

Line 408: FROM pay_balance_batch_lines bl

404: OR ( upper(bh.business_group_name) = upper(l_business_group_name)) );
405: --
406: CURSOR pbl (p_batch in number) IS
407: SELECT bl.batch_line_id
408: FROM pay_balance_batch_lines bl
409: where bl.batch_id = p_batch;
410: --
411: begin
412: --

Line 434: DELETE FROM pay_balance_batch_lines bl

430: DELETE FROM pay_message_lines
431: WHERE source_id = pbhrec.batch_id
432: AND source_type = 'H';
433: end if;
434: DELETE FROM pay_balance_batch_lines bl
435: WHERE bl.batch_id = pbhrec.batch_id;
436: --
437: DELETE FROM pay_balance_batch_headers bh
438: WHERE bh.batch_id = pbhrec.batch_id;