APPS.CN_SRP_PERIODS_PVT dependencies on CN_PERIOD_STATUSES

Line 20: l_start_date cn_period_statuses.start_date%TYPE;

16: p_period_set_id IN NUMBER,
17: p_period_type_id IN NUMBER,
18: p_org_id IN NUMBER) RETURN pay_period_rec_tbl_type IS
19: l_pay_period_rec_tbl pay_period_rec_tbl_type;
20: l_start_date cn_period_statuses.start_date%TYPE;
21: l_end_date cn_period_statuses.end_date%TYPE;
22: l_index NUMBER;
23:
24: CURSOR c_period_rec_csr

Line 21: l_end_date cn_period_statuses.end_date%TYPE;

17: p_period_type_id IN NUMBER,
18: p_org_id IN NUMBER) RETURN pay_period_rec_tbl_type IS
19: l_pay_period_rec_tbl pay_period_rec_tbl_type;
20: l_start_date cn_period_statuses.start_date%TYPE;
21: l_end_date cn_period_statuses.end_date%TYPE;
22: l_index NUMBER;
23:
24: CURSOR c_period_rec_csr
25: ( c_start_date cn_period_statuses.start_date%TYPE,

Line 25: ( c_start_date cn_period_statuses.start_date%TYPE,

21: l_end_date cn_period_statuses.end_date%TYPE;
22: l_index NUMBER;
23:
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

Line 26: c_end_date cn_period_statuses.end_date%TYPE) IS

22: l_index NUMBER;
23:
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

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 90: l_prev_pd_id cn_period_statuses.period_id%TYPE := -1;

86: p_credit_type_id IN NUMBER,
87: p_role_id IN NUMBER,
88: p_start_period_id IN NUMBER) IS
89:
90: l_prev_pd_id cn_period_statuses.period_id%TYPE := -1;
91: l_prev_year cn_period_statuses.period_year%TYPE := -1;
92: l_prev_quota cn_srp_periods.quota_id%TYPE := -1;
93: l_prev_spa cn_srp_periods.srp_plan_assign_id%TYPE := -1;
94: l_reset_balances boolean := false;

Line 91: l_prev_year cn_period_statuses.period_year%TYPE := -1;

87: p_role_id IN NUMBER,
88: p_start_period_id IN NUMBER) IS
89:
90: l_prev_pd_id cn_period_statuses.period_id%TYPE := -1;
91: l_prev_year cn_period_statuses.period_year%TYPE := -1;
92: l_prev_quota cn_srp_periods.quota_id%TYPE := -1;
93: l_prev_spa cn_srp_periods.srp_plan_assign_id%TYPE := -1;
94: l_reset_balances boolean := false;
95: l_srp_period_id number;

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