APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PERIODS_ALL

Line 1129: FROM cn_srp_periods_all

1125: role_id ,
1126: balance2_dtd ,
1127: balance3_ctd ,
1128: srp_period_id
1129: FROM cn_srp_periods_all
1130: WHERE quota_id = x_quota_id
1131: AND org_id = l_org_id
1132: AND EXISTS
1133: (SELECT 1

Line 1137: AND cn_srp_periods_all.period_id = p.period_id

1133: (SELECT 1
1134: FROM cn_period_statuses p
1135: WHERE TRUNC(p.start_date) >= TRUNC(NVL(x_start_date,p.start_date))
1136: AND TRUNC(p.end_date) <= TRUNC(NVL(x_end_date ,p.end_date))
1137: AND cn_srp_periods_all.period_id = p.period_id
1138: AND p.period_status IN ('O', 'F')
1139: AND cn_srp_periods_all.org_id = p.org_id
1140: )
1141: AND (balance2_dtd <> 0

Line 1139: AND cn_srp_periods_all.org_id = p.org_id

1135: WHERE TRUNC(p.start_date) >= TRUNC(NVL(x_start_date,p.start_date))
1136: AND TRUNC(p.end_date) <= TRUNC(NVL(x_end_date ,p.end_date))
1137: AND cn_srp_periods_all.period_id = p.period_id
1138: AND p.period_status IN ('O', 'F')
1139: AND cn_srp_periods_all.org_id = p.org_id
1140: )
1141: AND (balance2_dtd <> 0
1142: OR balance3_ctd <> 0)
1143: ORDER BY salesrep_id,