APPS.CN_API dependencies on DUAL

Line 2147: FROM sys.dual;

2143: CLOSE get_closest_date;
2144: END;
2145: ELSE
2146: SELECT Nvl(p_credit_unit,0) INTO l_conv_amount
2147: FROM sys.dual;
2148: END IF;
2149:
2150: l_repcurr_amount :=
2151: gl_currency_api.convert_amount

Line 2255: FROM sys.dual;

2251: CLOSE get_closest_date;
2252: END;
2253: ELSE
2254: SELECT Nvl(p_credit_unit,0) INTO l_conv_amount
2255: FROM sys.dual;
2256: END IF;
2257:
2258: -- dbms_output.put_line('p_conv_date = ' || p_conv_date);
2259: -- dbms_output.put_line('p_conv_type = ' || p_conv_type);

Line 3045: SELECT 1 INTO l_exist FROM dual WHERE EXISTS

3041: BEGIN
3042: l_exist := 0;
3043: BEGIN
3044: -- isPayee if assigned to srp in this period
3045: SELECT 1 INTO l_exist FROM dual WHERE EXISTS
3046: (SELECT 1
3047: FROM cn_srp_payee_assigns cnspay, cn_period_statuses cnps
3048: WHERE cnspay.payee_id = p_salesrep_id
3049: AND cnps.period_id = p_period_id

Line 3063: SELECT 1 INTO l_exist FROM dual WHERE EXISTS

3059: WHEN NO_DATA_FOUND THEN
3060: l_exist := 0;
3061: BEGIN
3062: -- isPayee if have Payee role in this period
3063: SELECT 1 INTO l_exist FROM dual WHERE EXISTS
3064: (SELECT 1 FROM cn_srp_roles sr, cn_period_statuses cnps
3065: WHERE sr.salesrep_id = p_salesrep_id
3066: AND sr.role_id = 54
3067: AND sr.org_id = p_org_id