APPS.IEX_SCORE_NEW_PVT dependencies on IEX_SCORE_COMP_TYPES_TL

Line 1197: iex_score_comp_types_tl sc_typ_tl,

1193: sc.score_comp_weight,
1194: sc_typ.score_comp_value
1195: into l_score_comp_name,l_function_flg,l_score_comp_wgt,l_score_comp_val
1196: FROM iex_score_components sc,
1197: iex_score_comp_types_tl sc_typ_tl,
1198: iex_score_comp_types_b sc_typ
1199: WHERE sc.score_comp_type_id = sc_typ.score_comp_type_id
1200: AND sc_typ.score_comp_type_id= sc_typ_tl.score_comp_type_id
1201: AND sc_typ_tl.language ='US'

Line 2851: from iex_score_components sc, iex_score_comp_types_tl sctl

2847: l_xml_body_1:=l_xml_body_1||l_new_line||''||l_score_component_id||'';
2848: begin
2849: select sctl.score_comp_name,sc.score_comp_weight
2850: into l_score_comp_name,l_score_comp_wtg
2851: from iex_score_components sc, iex_score_comp_types_tl sctl
2852: where sc.score_comp_type_id=sctl.score_comp_type_id
2853: and sc.score_component_id=l_score_component_id
2854: and sctl.language='US';
2855: l_xml_body_1:=l_xml_body_1||l_new_line||''||format_string(l_score_comp_name)||'';