APPS.CN_SRP_PRD_QUOTA_PUB dependencies on CN_PERIOD_STATUSES

Line 44: tbl_period_id CN_PERIOD_STATUSES.period_id%TYPE;

40: l_customized_flag CN_SRP_quota_ASSIGNS.customized_flag%TYPE;
41:
42: l_period_target_unit_code CN_SRP_quota_ASSIGNS.period_target_unit_code%TYPE;
43:
44: tbl_period_id CN_PERIOD_STATUSES.period_id%TYPE;
45: tbl_srp_period_quota_id CN_SRP_PERIOD_QUOTAS.srp_period_quota_id%TYPE;
46: tbl_quarter_num CN_SRP_PERIOD_QUOTAS_V.quarter_num%TYPE;
47: tbl_period_year CN_SRP_PERIOD_QUOTAS_V.period_year%TYPE;
48: l_prd_count NUMBER;

Line 136: from cn_period_statuses

132: and period_id = p_period_id;
133:
134: CURSOR l_period_id_cr(p_period_name VARCHAR2) IS
135: select *
136: from cn_period_statuses
137: where period_name = p_period_name
138: AND org_id = l_org_id;
139:
140: f_quota_row_rec CN_QUOTAS%ROWTYPE;

Line 147: f_period_id_rec CN_PERIOD_STATUSES%ROWTYPE;

143: f_role_id_rec CN_ROLES%ROWTYPE;
144: f_comp_plan_id_rec CN_COMP_PLANS%ROWTYPE;
145: f_srp_plan_assign_id_rec CN_SRP_PLAN_ASSIGNS%ROWTYPE;
146: f_srp_quota_assign_id_rec CN_SRP_QUOTA_ASSIGNS%ROWTYPE;
147: f_period_id_rec CN_PERIOD_STATUSES%ROWTYPE;
148: f_period_quota_info_rec cn_srp_period_quotas_v%ROWTYPE;
149:
150:
151: