DBA Data[Home] [Help]

APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_SEGMENTS_TL

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

5751: );*/
5752: Begin
5753: select language_code into l_lang_code from fnd_languages where installed_flag='B';
5754:
5755: select user_segment_name into out_benefit_method from qp_segments_tl qst,qp_segments_b qsb
5756: where qst.segment_id= qsb.segment_id and qsb.segment_code=l_benefit_method and qst.language=l_lang_code;
5757: Exception
5758: When Others then
5759: oe_Debug_pub.add(' Exception while queries for terms and language code'||SQLCODE||SQLERRM);