APPS.CN_SRP_PERIODS_PVT dependencies on CN_PERIOD_STATUSES_ALL

Line 28: FROM cn_period_statuses_all

24: CURSOR c_period_rec_csr
25: ( c_start_date cn_period_statuses.start_date%TYPE,
26: c_end_date cn_period_statuses.end_date%TYPE) IS
27: SELECT period_id , start_date, end_date
28: FROM cn_period_statuses_all
29: WHERE start_date <= c_end_date
30: AND end_date >= c_start_date
31: AND period_type_id = p_period_type_id
32: AND period_set_id = p_period_set_id

Line 121: FROM cn_srp_periods_all sp, cn_period_statuses_all p

117: balance4_ctd, balance4_dtd,
118: balance4_bbc, balance4_bbd,
119: balance5_ctd, balance5_dtd,
120: balance5_bbc, balance5_bbd
121: FROM cn_srp_periods_all sp, cn_period_statuses_all p
122: WHERE role_id = p_role_id
123: AND salesrep_id = p_salesrep_id
124: AND sp.org_id = p_org_id
125: AND credit_type_id = p_credit_type_id

Line 157: cn_period_statuses_all p

153: nvl(sum(p2.balance5_bbc),0) balance5_bbc,
154: nvl(sum(p2.balance5_bbd),0) balance5_bbd,
155: p.period_year
156: from cn_srp_periods_all p1, cn_srp_periods_all p2,
157: cn_period_statuses_all p
158: where p1.salesrep_id = p_salesrep_id
159: and p1.credit_type_id = p_credit_type_id
160: AND p1.org_id = p_org_id
161: and p1.quota_id is null and p1.role_id is null

Line 459: from cn_period_statuses_all p, cn_repositories_all r

455:
456:
457: CURSOR get_summ_pds(c_credit_type_id cn_srp_periods.credit_type_id%TYPE) IS
458: select p.period_id, p.start_date, p.end_date
459: from cn_period_statuses_all p, cn_repositories_all r
460: where p.period_id >= l_min_period_id
461: and r.period_type_id = p.period_type_id
462: and r.period_set_id = p.period_set_id
463: AND p.org_id = l_org_id

Line 475: from cn_period_statuses_all p, cn_repositories_all r

471: order by 1;
472:
473: CURSOR get_carry_pds(c_credit_type_id cn_srp_periods.credit_type_id%TYPE) IS
474: select p.period_id, p.start_date, p.end_date
475: from cn_period_statuses_all p, cn_repositories_all r
476: where p.period_id >= l_min_period_id
477: and r.period_type_id = p.period_type_id
478: and r.period_set_id = p.period_set_id
479: AND p.org_id = l_org_id