APPS.CN_SRP_PRD_QUOTA_PUB dependencies on CN_SRP_PERIOD_QUOTAS_V

Line 46: tbl_quarter_num CN_SRP_PERIOD_QUOTAS_V.quarter_num%TYPE;

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;
49: l_upd_srp_quota_assign VARCHAR2(1);
50: l_commission_payed_ptd CN_SRP_PERIOD_QUOTAS.commission_payed_ptd%TYPE;

Line 47: tbl_period_year CN_SRP_PERIOD_QUOTAS_V.period_year%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;
49: l_upd_srp_quota_assign VARCHAR2(1);
50: l_commission_payed_ptd CN_SRP_PERIOD_QUOTAS.commission_payed_ptd%TYPE;
51:

Line 119: FROM cn_srp_period_quotas_v

115: and quota_id = p_quota_id;
116:
117: CURSOR l_srp_prd_quota_cr(p_srp_quota_assign_id NUMBER) IS
118: SELECT *
119: FROM cn_srp_period_quotas_v
120: WHERE srp_quota_assign_id = p_srp_quota_assign_id;
121:
122: CURSOR f_quota_row(p_quota_id NUMBER) IS
123: SELECT *

Line 130: from cn_srp_period_quotas_v

126:
127: CURSOR tbl_period_quota_info_cr(p_period_id NUMBER,
128: p_srp_quota_assign_id NUMBER) IS
129: select *
130: from cn_srp_period_quotas_v
131: where srp_quota_assign_id = p_srp_quota_assign_id
132: and period_id = p_period_id;
133:
134: CURSOR l_period_id_cr(p_period_name VARCHAR2) IS

Line 148: f_period_quota_info_rec cn_srp_period_quotas_v%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:
152: BEGIN