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 784: FROM DUAL;

780: ELSE
781: --
782: SELECT SYSDATE
783: INTO x_cum_record.actual_shipment_date
784: FROM DUAL;
785: --
786: END IF;
787: --
788: x_cum_record.cum_key_created_flag := x_cum_key_created_flag;

Line 1080: FROM DUAL;

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

Line 1154: FROM DUAL;

1150: -1, '0'||to_char(rlm_setup_record.cum_yesterd_time_cutoff),
1151: to_char(rlm_setup_record.cum_yesterd_time_cutoff)),
1152: 'DD/MM/YYYY HH24MI')
1153: INTO x_cum_record.yesterday_time_cutoff
1154: FROM DUAL;
1155: --
1156: v_cutoff_date := x_cum_record.yesterday_time_cutoff;
1157: --
1158: END IF;

Line 1911: FROM DUAL;

1907: BEGIN
1908: --
1909: SELECT v_new_ship_count(v_cum_record.cum_key_id) + 1
1910: INTO v_new_ship_count(v_cum_record.cum_key_id)
1911: FROM DUAL;
1912: --
1913: EXCEPTION
1914: --
1915: WHEN NO_DATA_FOUND THEN

Line 1921: FROM DUAL;

1917: v_new_ship_count(v_cum_record.cum_key_id) := 0;
1918: --
1919: SELECT v_new_ship_count(v_cum_record.cum_key_id) + 1
1920: INTO v_new_ship_count(v_cum_record.cum_key_id)
1921: FROM DUAL;
1922: --
1923: END;
1924: ------------------------------------------------------------+
1925: --