APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_SEGMENTS_TL

Line 5730: select user_segment_name into out_benefit_method from qp_segments_tl qst,qp_segments_b qsb

5726: );*/
5727: Begin
5728: select language_code into l_lang_code from fnd_languages where installed_flag='B';
5729:
5730: select user_segment_name into out_benefit_method from qp_segments_tl qst,qp_segments_b qsb
5731: where qst.segment_id= qsb.segment_id and qsb.segment_code=l_benefit_method and qst.language=l_lang_code;
5732: Exception
5733: When Others then
5734: oe_Debug_pub.add(' Exception while queries for terms and language code'||SQLCODE||SQLERRM);