APPS.PA_CI_TYPES_PVT dependencies on PA_CI_TYPES_V

Line 471: from pa_ci_types_v pct,

467:
468: -- Check if direct/supplier cost regions have been created in budgets?
469: CURSOR new_fin_impacts_csr (p_ci_type_id pa_ci_types_b.CI_TYPE_ID%type) is
470: select 1
471: from pa_ci_types_v pct,
472: pa_control_items pci,
473: pa_budget_versions pbv
474: where pct.ci_type_id = pci.ci_type_id
475: and pci.ci_id = pbv.ci_id

Line 798: FROM pa_ci_types_vl

794: resolution_category
795: INTO l_classification_category,
796: l_reason_category,
797: l_resolution_category
798: FROM pa_ci_types_vl
799: WHERE ci_type_id = p_ci_type_id
800: AND record_version_number = p_record_version_number;
801:
802: p_record_version_number := p_record_version_number+1;

Line 1063: FROM pa_ci_types_vl

1059:
1060: -- Validate the record version number
1061: BEGIN
1062: SELECT 'X' INTO l_temp
1063: FROM pa_ci_types_vl
1064: WHERE ci_type_id = p_ci_type_id
1065: AND record_version_number = p_record_version_number;
1066: EXCEPTION
1067: WHEN NO_DATA_FOUND THEN