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 317: FROM cn_acc_period_statuses_v

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

Line 494: FROM cn_acc_period_statuses_v

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