DBA Data[Home] [Help]

APPS.PA_FP_CI_INCLUDE_PKG dependencies on PA_CI_IMPACT_TYPE_USAGE

Line 376: pa_ci_impact_type_usage targetUsage

372: AND a.impact_type_code IN ('FINPLAN_COST','FINPLAN_REVENUE','FINPLAN')
373: AND (a.impact_type_code = 'FINPLAN' OR
374: EXISTS (SELECT 1
375: FROM pa_control_items targetCi,
376: pa_ci_impact_type_usage targetUsage
377: WHERE targetCi.ci_id = p_target_ci_id
378: AND targetCi.ci_type_id = targetUsage.ci_type_id
379: AND targetUsage.impact_type_code = a.impact_type_code));
380:

Line 464: pa_ci_impact_type_usage pcit

460: -- Check if change order type allows either of cost, revenue impacts
461: SELECT count(*)
462: INTO l_allowed_impacts_count
463: FROM pa_control_items pci,
464: pa_ci_impact_type_usage pcit
465: WHERE pci.ci_type_id = pcit.ci_type_id
466: AND pci.ci_id = p_target_ci_id
467: AND impact_type_code IN ('FINPLAN_COST','FINPLAN_REVENUE');
468: