DBA Data[Home] [Help]

APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SALESREPS

Line 946: FROM cn_srp_period_quotas_all period, cn_salesreps srp,

942: -- added for intelligent calculation
943: CURSOR l_get_intel_temp_csr IS
944: SELECT period.target_amount, period.period_payment,
945: srp.name, acc.start_date, acc.end_date, srp.org_id
946: FROM cn_srp_period_quotas_all period, cn_salesreps srp,
947: cn_period_statuses acc
948: WHERE period.srp_period_quota_id = x_srp_period_quota_id
949: AND acc.period_id = period.period_id
950: AND acc.org_id = period.org_id