DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_ROLLOVER_QUOTAS_ALL

Line 1081: FROM cn_srp_rollover_quotas_all csrq,

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