APPS.CN_API dependencies on DUAL

Line 2169: FROM sys.dual;

2165: CLOSE get_closest_date;
2166: END;
2167: ELSE
2168: SELECT Nvl(p_credit_unit,0) INTO l_conv_amount
2169: FROM sys.dual;
2170: END IF;
2171:
2172: l_repcurr_amount :=
2173: gl_currency_api.convert_amount

Line 2277: FROM sys.dual;

2273: CLOSE get_closest_date;
2274: END;
2275: ELSE
2276: SELECT Nvl(p_credit_unit,0) INTO l_conv_amount
2277: FROM sys.dual;
2278: END IF;
2279:
2280: -- dbms_output.put_line('p_conv_date = ' || p_conv_date);
2281: -- dbms_output.put_line('p_conv_type = ' || p_conv_type);

Line 3067: SELECT 1 INTO l_exist FROM dual WHERE EXISTS

3063: BEGIN
3064: l_exist := 0;
3065: BEGIN
3066: -- isPayee if assigned to srp in this period
3067: SELECT 1 INTO l_exist FROM dual WHERE EXISTS
3068: (SELECT 1
3069: FROM cn_srp_payee_assigns cnspay, cn_period_statuses cnps
3070: WHERE cnspay.payee_id = p_salesrep_id
3071: AND cnps.period_id = p_period_id

Line 3085: SELECT 1 INTO l_exist FROM dual WHERE EXISTS

3081: WHEN NO_DATA_FOUND THEN
3082: l_exist := 0;
3083: BEGIN
3084: -- isPayee if have Payee role in this period
3085: SELECT 1 INTO l_exist FROM dual WHERE EXISTS
3086: (SELECT 1 FROM cn_srp_roles sr, cn_period_statuses cnps
3087: WHERE sr.salesrep_id = p_salesrep_id
3088: AND sr.role_id = 54
3089: AND sr.org_id = p_org_id