DBA Data[Home] [Help]

APPS.PA_CI_IMPACTS_UTIL dependencies on PA_CI_IMPACT_TYPE_USAGE

Line 211: pa_ci_impact_type_usage targetUsage

207: IS
208: SELECT sourceImpacts.*
209: FROM pa_ci_impacts sourceImpacts,
210: pa_control_items targetCi,
211: pa_ci_impact_type_usage targetUsage
212: WHERE sourceImpacts.ci_id = p_source_ci_id
213: AND sourceImpacts.impact_type_code NOT IN ('FINPLAN_COST','FINPLAN_REVENUE','FINPLAN')
214: AND targetCi.ci_id = p_dest_ci_id
215: AND targetCi.ci_type_id = targetUsage.ci_type_id

Line 253: pa_ci_impact_type_usage pcit

249: and not exists
250: (
251: select * from
252: pa_control_items pci2,
253: pa_ci_impact_type_usage pcit
254: where pci2.ci_type_id = pcit.ci_type_id
255: AND pci2.ci_id = p_dest_ci_id
256: and pcit.impact_type_code = pci.impact_type_code
257: )