DBA Data[Home] [Help]

APPS.CN_GET_COMM_SUMM_DATA dependencies on FND_API

Line 192: AND nvl(quota.quota_group_code, FND_API.G_MISS_CHAR) =

188: cn_quotas quota
189: WHERE cspq.period_id = p_period_id
190: AND cspq.srp_plan_assign_id = l_srp_plan_assign_id
191: AND cspq.quota_id = quota.quota_id
192: AND nvl(quota.quota_group_code, FND_API.G_MISS_CHAR) =
193: nvl(l_quota_group_code , FND_API.G_MISS_CHAR)
194: AND quota.credit_type_id = p_credit_type_id
195: GROUP BY cspq.salesrep_id,
196: cspq.srp_plan_assign_id,

Line 193: nvl(l_quota_group_code , FND_API.G_MISS_CHAR)

189: WHERE cspq.period_id = p_period_id
190: AND cspq.srp_plan_assign_id = l_srp_plan_assign_id
191: AND cspq.quota_id = quota.quota_id
192: AND nvl(quota.quota_group_code, FND_API.G_MISS_CHAR) =
193: nvl(l_quota_group_code , FND_API.G_MISS_CHAR)
194: AND quota.credit_type_id = p_credit_type_id
195: GROUP BY cspq.salesrep_id,
196: cspq.srp_plan_assign_id,
197: cspq.period_id;