APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_SEGMENTS_B

Line 5736: select segment_code into l_benefit_method from qp_segments_b qsb,qp_prc_contexts_b qpcb

5732: oe_debug_pub.add('entering terms with parameter Substitution attribute'||in_substitution_attribute||'substituion'||
5733: in_substitution_to);
5734: end if;
5735: Begin
5736: select segment_code into l_benefit_method from qp_segments_b qsb,qp_prc_contexts_b qpcb
5737: where qsb.prc_context_id=qpcb.prc_context_id and
5738: qsb.segment_mapping_column=in_substitution_attribute and qpcb.prc_context_code='TERMS';
5739: Exception
5740: When others then

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);