APPS.RLM_PS_SV dependencies on RLM_INTERFACE_HEADERS

Line 124: from rlm_interface_headers rh, rlm_interface_lines_all rl '

120: || ' and rh.process_status = :k_ps_5'
121: || ' and rh.org_id = rl.org_id';
122:
123: v_int_statement := 'select distinct rh.header_id
124: from rlm_interface_headers rh, rlm_interface_lines_all rl '
125: || v_where_clause
126: ||' and 5 = :k_ps_5'
127: ||' and rh.org_id = rl.org_id';
128:

Line 817: FROM rlm_interface_headers

813: x_purge_rec.SCHEDULE_TYPE,
814: x_purge_rec.SCHED_GENERATION_DATE,
815: x_purge_rec.ORIGIN_TABLE, /*2261812*/
816: v_process_status
817: FROM rlm_interface_headers
818: WHERE header_id = v_sched_header_id;
819:
820: --check for partially selected schedule
821:

Line 920: delete from rlm_interface_headers where header_id = v_sched_header_id;

916: x_PurgeStatus => 'Y',
917: x_PurgeExp_rec=>x_purge_rec );
918: --
919: delete from rlm_interface_lines where header_id = v_sched_header_id;
920: delete from rlm_interface_headers where header_id = v_sched_header_id;
921: --
922: --delete from archive as well
923: --
924: delete from rlm_schedule_lines_all

Line 979: delete from rlm_interface_headers where header_id = v_sched_header_id;

975: rlm_core_sv.dlog(C_DEBUG,'Authorization not found, deleting....',v_sched_header_id);
976: END IF;
977:
978: delete from rlm_interface_lines where header_id = v_sched_header_id;
979: delete from rlm_interface_headers where header_id = v_sched_header_id;
980:
981: --delete from archive as well
982:
983: delete from rlm_schedule_lines where header_id = (select header_id from rlm_schedule_headers where interface_header_id = v_sched_header_id);