APPS.HXC_INLINE_NOTIF_UTILS_PKG dependencies on HXC_LAYOUT_COMP_QUALIFIERS

Line 764: l_select hxc_layout_comp_qualifiers.qualifier_attribute27%type;

760: TYPE AliasValueCurTyp IS REF CURSOR;
761:
762: aliasval_cv AliasValueCurTyp;
763:
764: l_select hxc_layout_comp_qualifiers.qualifier_attribute27%type;
765: l_time_building_block_id number;
766: l_time_building_block_ovn number;
767: l_query varchar2(32000);
768: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%type;

Line 782: from HXC_LAYOUT_COMP_QUALIFIERS where LAYOUT_COMPONENT_ID = p_layout_comp_id ;

778:
779: cursor get_alias_list(p_layout_comp_id in number)
780: is
781: select QUALIFIER_ATTRIBUTE28||'|'||QUALIFIER_ATTRIBUTE28||'|'||QUALIFIER_ATTRIBUTE7
782: from HXC_LAYOUT_COMP_QUALIFIERS where LAYOUT_COMPONENT_ID = p_layout_comp_id ;
783:
784: cursor get_alias_location(p_layout_comp_id in number,p_alias_name in varchar2)
785: is
786: SELECT

Line 790: Hxc_Layout_Comp_Qualifiers A,

786: SELECT
787: Distinct A.Qualifier_Attribute26,
788: A.Qualifier_Attribute27
789: FROM
790: Hxc_Layout_Comp_Qualifiers A,
791: Hxc_Layout_Components B,
792: Hxc_Layouts C
793: WHERE
794: C.Layout_Id = (Select Layout_Id From Hxc_Layout_Components Where Layout_Component_Id = P_Layout_Comp_Id) And