DBA Data[Home] [Help]

APPS.CN_SRP_PERIODS_PKG dependencies on CN_PERIOD_STATUSES_ALL

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