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:
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 139: from pa_ci_impact_type_usage

135: elsif (ci_type_impact%found and impact_1 = 'Y') then
136: begin
137: select 'Y'
138: into temp
139: from pa_ci_impact_type_usage
140: where ci_type_id = p_ci_type_id_2
141: and impact_type_code <> 'FINPLAN' /* Bug# 3724520 */
142: and impact_Type_code not in (select impact_Type_code
143: from pa_ci_impact_type_usage

Line 143: from pa_ci_impact_type_usage

139: from pa_ci_impact_type_usage
140: where ci_type_id = p_ci_type_id_2
141: and impact_type_code <> 'FINPLAN' /* Bug# 3724520 */
142: and impact_Type_code not in (select impact_Type_code
143: from pa_ci_impact_type_usage
144: where ci_type_id = p_ci_type_id_1
145: and impact_type_code <> 'FINPLAN'); /* Bug# 3724520 */
146: return 'N';
147: exception when no_data_found then

Line 170: from pa_ci_impact_type_usage

166: from pa_ci_impacts
167: where ci_id = p_ci_id_2
168: and impact_type_code <> 'FINPLAN' /* Bug# 3724520 */
169: and impact_Type_code not in (select impact_Type_code
170: from pa_ci_impact_type_usage
171: where ci_type_id = p_ci_type_id_1
172: and impact_type_code <> 'FINPLAN'); /* Bug# 3724520 */
173: return 'N';
174: exception when no_data_found then

Line 414: from pa_ci_impact_type_usage CIIU

410: select 'Y'
411: into l_ci_type_has_impact
412: from dual
413: where exists ( select '1'
414: from pa_ci_impact_type_usage CIIU
415: ,pa_control_items CI
416: where CIIU.ci_type_id= CI.ci_type_id
417: and CI.CI_id = p_ci_id ) ;
418: g_ci_type_has_impact := l_ci_type_has_impact ;

Line 448: from pa_ci_impact_type_usage CIIU

444: select 'Y'
445: into l_type_has_impact
446: from dual
447: where exists ( select '1'
448: from pa_ci_impact_type_usage CIIU
449: where CIIU.ci_type_id = p_ci_type_id
450: ) ;
451: g_type_has_impact := l_type_has_impact ;
452: END IF ;