APPS.HXC_INLINE_NOTIF_UTILS_PKG dependencies on HXC_LAYOUT_COMP_QUALIFIERS

Line 763: l_select hxc_layout_comp_qualifiers.qualifier_attribute27%type;

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

Line 781: from HXC_LAYOUT_COMP_QUALIFIERS where LAYOUT_COMPONENT_ID = p_layout_comp_id ;

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

Line 789: Hxc_Layout_Comp_Qualifiers A,

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