APPS.CN_IMP_TRXAPI_PVT dependencies on CN_ACC_PERIOD_STATUSES_V

Line 182: l_period_id cn_acc_period_statuses_v.period_id%TYPE;

178: l_trxapi_imp c_trxapi_imp_csr%ROWTYPE;
179: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
180: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;
181: l_role_id cn_roles.role_id%TYPE;
182: l_period_id cn_acc_period_statuses_v.period_id%TYPE;
183: l_rollup_period_id cn_acc_period_statuses_v.period_id%TYPE;
184: l_quota_id cn_quotas.quota_id%TYPE;
185: l_comp_group_id cn_comp_groups.comp_group_id%TYPE;
186: l_meaning cn_lookups.meaning%TYPE;

Line 183: l_rollup_period_id cn_acc_period_statuses_v.period_id%TYPE;

179: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
180: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;
181: l_role_id cn_roles.role_id%TYPE;
182: l_period_id cn_acc_period_statuses_v.period_id%TYPE;
183: l_rollup_period_id cn_acc_period_statuses_v.period_id%TYPE;
184: l_quota_id cn_quotas.quota_id%TYPE;
185: l_comp_group_id cn_comp_groups.comp_group_id%TYPE;
186: l_meaning cn_lookups.meaning%TYPE;
187:

Line 316: FROM cn_acc_period_statuses_v

312: -- get process_period_id
313: BEGIN
314: SELECT period_id
315: INTO l_period_id
316: FROM cn_acc_period_statuses_v
317: WHERE l_trxapi_imp.processed_date BETWEEN start_date AND end_date
318: AND period_status IN ('O','F') and org_id = p_org_id;
319: EXCEPTION
320: WHEN no_data_found THEN

Line 493: FROM cn_acc_period_statuses_v

489: IF l_trxapi_imp.rollup_date IS NOT NULL THEN
490: BEGIN
491: SELECT period_id
492: INTO l_rollup_period_id
493: FROM cn_acc_period_statuses_v
494: WHERE l_trxapi_imp.rollup_date BETWEEN start_date AND end_date
495: AND period_status IN ('O','F') and org_id = p_org_id;
496: EXCEPTION
497: WHEN no_data_found THEN