APPS.RLM_VALIDATEDEMAND_SV dependencies on DUAL

Line 2491: FROM dual;

2487: x_match_rec.attribute12,
2488: x_match_rec.attribute13,
2489: x_match_rec.attribute14,
2490: x_match_rec.attribute15
2491: FROM dual;
2492:
2493: IF (l_debug <> -1) THEN
2494: rlm_core_sv.dlog(C_DEBUG,'x_match_rec.cust_production_line',
2495: x_match_rec.cust_production_line);

Line 2922: FROM DUAL;

2918: --
2919: SELECT NEXT_DAY(v_End_Date_w,
2920: to_char(to_date(v_SundayDate, 'DD/MM/RRRR'), 'DY'))
2921: INTO v_End_Date_w
2922: FROM DUAL;
2923: --
2924: IF (l_debug <> -1) THEN
2925: rlm_core_sv.dlog(C_DEBUG,'Sunday after v_End_Date_w',v_End_Date_w);
2926: END IF;

Line 2930: FROM DUAL;

2926: END IF;
2927: --
2928: SELECT LAST_DAY(v_End_Date_m)
2929: INTO v_End_Date_m
2930: FROM DUAL;
2931: --
2932: IF (l_debug <> -1) THEN
2933: rlm_core_sv.dlog(C_DEBUG, 'Last day of the month of v_End_Date_m',
2934: v_End_Date_m);

Line 6071: (SELECT to_number(x_header_rec.customer_id) from dual

6067: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
6068: AND site_uses.site_use_code = 'SHIP_TO'
6069: AND acct_site.org_id = site_uses.org_id
6070: AND cust_account_id IN
6071: (SELECT to_number(x_header_rec.customer_id) from dual
6072: UNION
6073: SELECT cust_account_id
6074: FROM hz_cust_acct_relate_all
6075: WHERE related_cust_account_id = x_header_rec.customer_id

Line 6826: (SELECT to_number(x_header_rec.customer_id) from dual

6822: AND hz.cust_acct_site_id = hcsu.cust_acct_site_id
6823: AND site_use_code = 'SHIP_TO'
6824: AND hz.org_id = hcsu.org_id
6825: AND hz.cust_account_id IN
6826: (SELECT to_number(x_header_rec.customer_id) from dual
6827: UNION
6828: SELECT cust_account_id
6829: FROM hz_cust_acct_relate_all
6830: WHERE related_cust_account_id = x_header_rec.customer_id