APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_SEGMENTS_B

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

5707: oe_debug_pub.add('entering terms with parameter Substitution attribute'||in_substitution_attribute||'substituion'||
5708: in_substitution_to);
5709: end if;
5710: Begin
5711: select segment_code into l_benefit_method from qp_segments_b qsb,qp_prc_contexts_b qpcb
5712: where qsb.prc_context_id=qpcb.prc_context_id and
5713: qsb.segment_mapping_column=in_substitution_attribute and qpcb.prc_context_code='TERMS';
5714: Exception
5715: When others then

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