APPS.PA_CONTROL_ITEMS_UTILS dependencies on PA_CI_IMPACT_TYPE_USAGE

Line 103: from pa_ci_impact_type_usage

99: p_ci_id number;
100: impact_bud_type_code varchar2(30);
101: cursor ci_type_impact is
102: select impact_Type_code
103: from pa_ci_impact_type_usage
104: where ci_type_id = p_ci_type_id;
105:
106: cursor ci_impact is
107: select impact_type_code

Line 183: from pa_ci_impact_type_usage

179: elsif (ci_type_impact%found and impact_1 = 'Y') then
180: begin
181: select 'Y'
182: into temp
183: from pa_ci_impact_type_usage
184: where ci_type_id = p_ci_type_id_2
185: and impact_type_code <> 'FINPLAN' /* Bug# 3724520 */
186: and impact_Type_code not in (select impact_Type_code
187: from pa_ci_impact_type_usage

Line 187: from pa_ci_impact_type_usage

183: from pa_ci_impact_type_usage
184: where ci_type_id = p_ci_type_id_2
185: and impact_type_code <> 'FINPLAN' /* Bug# 3724520 */
186: and impact_Type_code not in (select impact_Type_code
187: from pa_ci_impact_type_usage
188: where ci_type_id = p_ci_type_id_1
189: and impact_type_code <> 'FINPLAN'); /* Bug# 3724520 */
190: return 'N';
191: exception when no_data_found then

Line 214: from pa_ci_impact_type_usage

210: from pa_ci_impacts
211: where ci_id = p_ci_id_2
212: and impact_type_code <> 'FINPLAN' /* Bug# 3724520 */
213: and impact_Type_code not in (select impact_Type_code
214: from pa_ci_impact_type_usage
215: where ci_type_id = p_ci_type_id_1
216: and impact_type_code <> 'FINPLAN'); /* Bug# 3724520 */
217: return 'N';
218: exception when no_data_found then

Line 458: from pa_ci_impact_type_usage CIIU

454: select 'Y'
455: into l_ci_type_has_impact
456: from dual
457: where exists ( select '1'
458: from pa_ci_impact_type_usage CIIU
459: ,pa_control_items CI
460: where CIIU.ci_type_id= CI.ci_type_id
461: and CI.CI_id = p_ci_id ) ;
462: g_ci_type_has_impact := l_ci_type_has_impact ;

Line 492: from pa_ci_impact_type_usage CIIU

488: select 'Y'
489: into l_type_has_impact
490: from dual
491: where exists ( select '1'
492: from pa_ci_impact_type_usage CIIU
493: where CIIU.ci_type_id = p_ci_type_id
494: ) ;
495: g_type_has_impact := l_type_has_impact ;
496: END IF ;