APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PERIODS_ALL

Line 1157: from cn_srp_periods_all

1153:
1154: CURSOR l_bal_id IS
1155: SELECT salesrep_id, period_id, credit_type_id, role_id,
1156: balance2_dtd, balance3_ctd, srp_period_id
1157: from cn_srp_periods_all
1158: where quota_id = x_quota_id
1159: AND org_id = l_org_id
1160: AND EXISTS ( SELECT 1 from cn_period_statuses p
1161: WHERE trunc(p.start_date) >= trunc(nvl(x_start_date,p.start_date))

Line 1163: AND cn_srp_periods_all.period_id = p.period_id

1159: AND org_id = l_org_id
1160: AND EXISTS ( SELECT 1 from cn_period_statuses p
1161: WHERE trunc(p.start_date) >= trunc(nvl(x_start_date,p.start_date))
1162: AND trunc(p.end_date) <= trunc(nvl(x_end_date ,p.end_date))
1163: AND cn_srp_periods_all.period_id = p.period_id
1164: AND p.period_status IN ('O', 'F')
1165: AND cn_srp_periods_all.org_id = p.org_id)
1166: AND (balance2_dtd <> 0 OR balance3_ctd <> 0)
1167: order by salesrep_id, credit_type_id, role_id, period_id;

Line 1165: AND cn_srp_periods_all.org_id = p.org_id)

1161: WHERE trunc(p.start_date) >= trunc(nvl(x_start_date,p.start_date))
1162: AND trunc(p.end_date) <= trunc(nvl(x_end_date ,p.end_date))
1163: AND cn_srp_periods_all.period_id = p.period_id
1164: AND p.period_status IN ('O', 'F')
1165: AND cn_srp_periods_all.org_id = p.org_id)
1166: AND (balance2_dtd <> 0 OR balance3_ctd <> 0)
1167: order by salesrep_id, credit_type_id, role_id, period_id;
1168: l_bal_rec l_bal_id%ROWTYPE;
1169: