DBA Data[Home] [Help]

APPS.HXC_HPH_UPLOAD_PKG dependencies on HXC_ENTITY_GROUP_COMPS

Line 93: l_attribute_id hxc_entity_group_comps.attribute1%TYPE;

89:
90: FUNCTION get_attribute_id ( p_attribute_category VARCHAR2
91: , p_attribute VARCHAR2 ) RETURN VARCHAR2 IS
92:
93: l_attribute_id hxc_entity_group_comps.attribute1%TYPE;
94:
95: CURSOR csr_get_approval_style_id IS
96: SELECT TO_CHAR(approval_style_id)
97: FROM hxc_approval_styles

Line 132: FROM hxc_entity_group_comps egc

128: WHERE layout_name = p_attribute;
129:
130: CURSOR csr_get_date_format IS
131: SELECT egc.attribute1
132: FROM hxc_entity_group_comps egc
133: WHERE egc.attribute2 = p_attribute
134: AND EXISTS ( SELECT 'x'
135: FROM hxc_entity_groups eg
136: WHERE eg.entity_group_id = egc.entity_group_id

Line 474: FROM hxc_entity_group_comps egc

470: WHERE layout_id = TO_NUMBER(p_attribute);
471:
472: CURSOR csr_get_date_format IS
473: SELECT egc.attribute2
474: FROM hxc_entity_group_comps egc
475: WHERE egc.attribute1 = p_attribute
476: AND EXISTS ( SELECT 'x'
477: FROM hxc_entity_groups eg
478: WHERE eg.entity_group_id = egc.entity_group_id