DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PVT dependencies on PA_CI_IMPACT_TYPE_USAGE

Line 87: pa_ci_impact_type_usage pcit,

83: --pl.meaning impact_name,
84: --pci.project_id project_id
85: from
86: pa_control_items pci,
87: pa_ci_impact_type_usage pcit,
88: pa_lookups pl
89: where pci.ci_type_id = pcit.ci_type_id
90: and pl.lookup_type = 'PA_CI_IMPACT_TYPES'
91: and decode(pcit.impact_type_code, 'FINPLAN_COST', 'FINPLAN', 'FINPLAN_REVENUE', 'FINPLAN', pcit.impact_type_code) = pl.lookup_code