APPS.CN_SRP_PERIODS_PKG dependencies on CN_PERIOD_STATUSES

Line 36: l_pre_period_year cn_period_statuses.period_year%TYPE;

32: p_period_id IN NUMBER,
33: x_srp_prd_row OUT NOCOPY cn_srp_periods%rowtype) IS
34:
35: l_max_end_date cn_srp_periods.end_date%TYPE;
36: l_pre_period_year cn_period_statuses.period_year%TYPE;
37: l_cur_period_year cn_period_statuses.period_year%TYPE;
38:
39:
40: BEGIN

Line 37: l_cur_period_year cn_period_statuses.period_year%TYPE;

33: x_srp_prd_row OUT NOCOPY cn_srp_periods%rowtype) IS
34:
35: l_max_end_date cn_srp_periods.end_date%TYPE;
36: l_pre_period_year cn_period_statuses.period_year%TYPE;
37: l_cur_period_year cn_period_statuses.period_year%TYPE;
38:
39:
40: BEGIN
41: -- Find closest previous record

Line 64: FROM cn_period_statuses_all

60: AND end_date = l_max_end_date;
61:
62: -- Get previous record's period_year
63: SELECT period_year INTO l_pre_period_year
64: FROM cn_period_statuses_all
65: WHERE period_id = x_srp_prd_row.period_id
66: AND org_id = p_org_id;
67: -- Get current record's period_year
68: SELECT period_year INTO l_cur_period_year

Line 69: FROM cn_period_statuses_all

65: WHERE period_id = x_srp_prd_row.period_id
66: AND org_id = p_org_id;
67: -- Get current record's period_year
68: SELECT period_year INTO l_cur_period_year
69: FROM cn_period_statuses_all
70: WHERE period_id = p_period_id
71: AND org_id = p_org_id;
72: -- Check if changing the period_year, if so, reset the value, do not
73: -- carry over