APPS.HXC_LOAD_PKG dependencies on HXC_ENTITY_GROUPS

Line 51: FROM hxc_entity_groups heg

47: CURSOR csr_get_application_set IS
48: SELECT aps.application_set_name
49: FROM (SELECT heg.rowid row_id ,heg.ENTITY_GROUP_ID application_set_id ,heg.NAME application_set_name ,heg.OBJECT_VERSION_NUMBER ,heg.CREATED_BY ,
50: heg.CREATION_DATE ,heg.LAST_UPDATED_BY ,heg.LAST_UPDATE_DATE ,heg.LAST_UPDATE_LOGIN
51: FROM hxc_entity_groups heg
52: WHERE heg.entity_type = 'TIME_RECIPIENTS') APS
53: WHERE aps.application_set_id = TO_NUMBER(p_attribute);
54:
55: CURSOR csr_get_retrieval_rule_grp IS

Line 59: FROM hxc_entity_groups heg

55: CURSOR csr_get_retrieval_rule_grp IS
56: SELECT ret.retrieval_rule_group_name
57: FROM (SELECT heg.rowid row_id ,heg.ENTITY_GROUP_ID retrieval_rule_group_id ,heg.NAME retrieval_rule_group_name ,heg.OBJECT_VERSION_NUMBER ,heg.CREATED_BY ,heg.CREATION_DATE ,
58: heg.LAST_UPDATED_BY ,heg.LAST_UPDATE_DATE ,heg.LAST_UPDATE_LOGIN
59: FROM hxc_entity_groups heg
60: WHERE heg.entity_type = 'RETRIEVAL_RULES') RET
61: WHERE ret.retrieval_rule_group_id = TO_NUMBER(p_attribute);
62:
63: CURSOR csr_get_public_template_group IS

Line 64: select heg.name FROM hxc_entity_groups heg where

60: WHERE heg.entity_type = 'RETRIEVAL_RULES') RET
61: WHERE ret.retrieval_rule_group_id = TO_NUMBER(p_attribute);
62:
63: CURSOR csr_get_public_template_group IS
64: select heg.name FROM hxc_entity_groups heg where
65: heg.entity_type = 'PUBLIC_TEMPLATE_GROUP' and
66: heg.ENTITY_GROUP_ID= TO_NUMBER(p_attribute);
67:
68: CURSOR csr_get_alias IS

Line 93: FROM hxc_entity_groups eg

89: SELECT egc.attribute2
90: FROM hxc_entity_group_comps egc
91: WHERE egc.attribute1 = p_attribute
92: AND EXISTS ( SELECT 'x'
93: FROM hxc_entity_groups eg
94: WHERE eg.entity_group_id = egc.entity_group_id
95: AND eg.entity_type = 'HXC_SS_TC_DATE_FORMATS' );
96:
97: CURSOR

Line 102: FROM hxc_entity_groups heg

98: csr_get_time_entry_rule_name IS
99: SELECT ter.time_entry_rule_group_name
100: FROM (SELECT heg.rowid row_id ,heg.ENTITY_GROUP_ID time_entry_rule_group_id ,heg.NAME time_entry_rule_Group_name ,
101: heg.OBJECT_VERSION_NUMBER ,heg.CREATED_BY ,heg.CREATION_DATE ,heg.LAST_UPDATED_BY ,heg.LAST_UPDATE_DATE ,heg.LAST_UPDATE_LOGIN
102: FROM hxc_entity_groups heg
103: WHERE heg.entity_type = 'TIME_ENTRY_RULES') TER
104: WHERE ter.time_entry_rule_group_id = TO_NUMBER(p_attribute);
105:
106: BEGIN