DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_ROLLOVER_QUOTAS_ALL

Line 1082: FROM cn_srp_rollover_quotas_all csrq,

1078:
1079: -- retrieve source plan elements' rollover targets and compute the total amount
1080: SELECT SUM(nvl(cspq.rollover, 0) * csrq.rollover / 100)
1081: INTO l_source_pe_rollover
1082: FROM cn_srp_rollover_quotas_all csrq,
1083: cn_srp_period_quotas_all cspq
1084: WHERE csrq.quota_id = p_quota_id
1085: AND csrq.srp_quota_assign_id = (SELECT srp_quota_assign_id
1086: FROM cn_srp_quota_assigns_all