APPS.PA_CI_IMPACT_TYPE_USAGE_PVT dependencies on PA_CI_TYPES_B

Line 337: CURSOR validate_impacts_csr (p_ci_type_id pa_ci_types_b.CI_TYPE_ID%type) is

333:
334: l_rowid VARCHAR2(30);
335: l_ci_impact_type_usage_id pa_ci_impact_type_usage.ci_impact_type_usage_id%type;
336:
337: CURSOR validate_impacts_csr (p_ci_type_id pa_ci_types_b.CI_TYPE_ID%type) is
338: select pc.impact_type_code,
339: luk.meaning impact_type_name
340: from pa_control_items pci,
341: pa_ci_impacts pc,

Line 363: CURSOR delete_impacts_csr (p_ci_type_id pa_ci_types_b.CI_TYPE_ID%type) is

359: l_supplier_cost_exists boolean := false;
360: l_supplier_exists boolean := false;
361:
362:
363: CURSOR delete_impacts_csr (p_ci_type_id pa_ci_types_b.CI_TYPE_ID%type) is
364: select pu.ci_impact_type_usage_id
365: from pa_ci_impact_type_usage pu
366: where pu.ci_type_id = p_ci_type_id;
367:

Line 370: CURSOR sync_budget_options_csr (p_ci_type_id pa_ci_types_b.CI_TYPE_ID%type) is

366: where pu.ci_type_id = p_ci_type_id;
367:
368: delete_impacts_rec delete_impacts_csr%ROWTYPE;
369: --cklee 5/1/09
370: CURSOR sync_budget_options_csr (p_ci_type_id pa_ci_types_b.CI_TYPE_ID%type) is
371: select ci.IMPACT_BUDGET_TYPE_CODE,
372: ci.COST_COL_FLAG,
373: ci.REV_COL_FLAG,
374: ci.DIR_COST_REG_FLAG,

Line 377: from pa_ci_types_b ci

373: ci.REV_COL_FLAG,
374: ci.DIR_COST_REG_FLAG,
375: ci.SUPP_COST_REG_FLAG,
376: ci.DIR_REG_REV_COL_FLAG
377: from pa_ci_types_b ci
378: where ci.ci_type_id = p_ci_type_id;
379:
380: l_direct_cost_RN_exists boolean := false;
381: sync_cnt number := 0;