APPS.RLM_CUM_SV dependencies on DUAL

Line 616: FROM DUAL;

612: v_OrgId);
613: --
614: SELECT rlm_cust_item_cum_keys_s.currval
615: INTO x_cum_record.cum_key_id
616: FROM DUAL;
617: --
618: x_cum_record.cum_start_date := p_cum_start_date;
619: x_cum_record.cum_key_created_flag := TRUE;
620: x_cum_record.record_return_status := TRUE;

Line 786: FROM DUAL;*/

782: --
783: --Bugfix 10053830 Start
784: /*SELECT SYSDATE
785: INTO x_cum_record.actual_shipment_date
786: FROM DUAL;*/
787: x_cum_record.actual_shipment_date := nvl(rlm_dp_sv.g_dsp_start_time,sysdate);
788: --Bugfix 10053830 End
789: --
790: END IF;

Line 1085: FROM DUAL;

1081: -1, '0'||to_char(rlm_setup_record.cum_yesterd_time_cutoff),
1082: to_char(rlm_setup_record.cum_yesterd_time_cutoff)),
1083: 'DD/MM/YYYY HH24MI')
1084: INTO x_cum_record.yesterday_time_cutoff
1085: FROM DUAL;
1086: --
1087: IF x_cum_key_record.called_by_reset_cum = 'N' THEN
1088: --
1089: /* Calculate supplier_cum based on all shipments dated

Line 1163: FROM DUAL;

1159: -1, '0'||to_char(rlm_setup_record.cum_yesterd_time_cutoff),
1160: to_char(rlm_setup_record.cum_yesterd_time_cutoff)),
1161: 'DD/MM/YYYY HH24MI')
1162: INTO x_cum_record.yesterday_time_cutoff
1163: FROM DUAL;
1164: --
1165: v_cutoff_date := x_cum_record.yesterday_time_cutoff;
1166: --
1167: END IF;

Line 1920: FROM DUAL;

1916: BEGIN
1917: --
1918: SELECT v_new_ship_count(v_cum_record.cum_key_id) + 1
1919: INTO v_new_ship_count(v_cum_record.cum_key_id)
1920: FROM DUAL;
1921: --
1922: EXCEPTION
1923: --
1924: WHEN NO_DATA_FOUND THEN

Line 1930: FROM DUAL;

1926: v_new_ship_count(v_cum_record.cum_key_id) := 0;
1927: --
1928: SELECT v_new_ship_count(v_cum_record.cum_key_id) + 1
1929: INTO v_new_ship_count(v_cum_record.cum_key_id)
1930: FROM DUAL;
1931: --
1932: END;
1933: ------------------------------------------------------------+
1934: --