DBA Data[Home] [Help]

APPS.CN_QUOTA_RULES_GRP dependencies on DUAL

Line 59: FROM SYS.DUAL;

55:
56: -- Set the Default Rev Class Target
57: SELECT DECODE (p_revenue_class_rec.rev_class_target, fnd_api.g_miss_num, 0, NULL, 0, p_revenue_class_rec.rev_class_target)
58: INTO l_pe_rec.rev_class_target
59: FROM SYS.DUAL;
60:
61: -- Set the Default value for Payment Amount
62: SELECT DECODE (p_revenue_class_rec.rev_class_payment_amount, fnd_api.g_miss_num, 0, NULL, 0, p_revenue_class_rec.rev_class_payment_amount)
63: INTO l_pe_rec.rev_class_payment_amount

Line 64: FROM SYS.DUAL;

60:
61: -- Set the Default value for Payment Amount
62: SELECT DECODE (p_revenue_class_rec.rev_class_payment_amount, fnd_api.g_miss_num, 0, NULL, 0, p_revenue_class_rec.rev_class_payment_amount)
63: INTO l_pe_rec.rev_class_payment_amount
64: FROM SYS.DUAL;
65:
66: -- Set the Default Value for Performance Goal
67: SELECT DECODE (p_revenue_class_rec.rev_class_performance_goal, fnd_api.g_miss_num, 0, NULL, 0, p_revenue_class_rec.rev_class_performance_goal)
68: INTO l_pe_rec.rev_class_performance_goal

Line 69: FROM SYS.DUAL;

65:
66: -- Set the Default Value for Performance Goal
67: SELECT DECODE (p_revenue_class_rec.rev_class_performance_goal, fnd_api.g_miss_num, 0, NULL, 0, p_revenue_class_rec.rev_class_performance_goal)
68: INTO l_pe_rec.rev_class_performance_goal
69: FROM SYS.DUAL;
70:
71: RETURN l_pe_rec;
72: END convert_rev_class_user_input;
73: