APPS.HXC_EGC_BUS dependencies on HXC_TIME_ENTRY_RULES

Line 288: FROM hxc_time_entry_rules ter

284: SELECT 'error'
285: FROM sys.dual
286: WHERE NOT EXISTS (
287: SELECT 'x'
288: FROM hxc_time_entry_rules ter
289: WHERE ter.time_entry_rule_id = p_entity_id );
290:
291: CURSOR csr_chk_tr IS
292: SELECT 'error'

Line 594: hxc_time_entry_rules hte1,

590: cursor csr_chk_dup_app is
591: select 'Y'
592: from hxc_entity_groups heg,
593: hxc_entity_group_comps hec,
594: hxc_time_entry_rules hte1,
595: hxc_time_entry_rules hte2
596: where heg.entity_type = 'TIME_ENTRY_RULES' and
597: heg.entity_group_id = nvl(p_entity_group_id,-999) and
598: hec.ENTITY_GROUP_ID =heg.entity_group_id and

Line 595: hxc_time_entry_rules hte2

591: select 'Y'
592: from hxc_entity_groups heg,
593: hxc_entity_group_comps hec,
594: hxc_time_entry_rules hte1,
595: hxc_time_entry_rules hte2
596: where heg.entity_type = 'TIME_ENTRY_RULES' and
597: heg.entity_group_id = nvl(p_entity_group_id,-999) and
598: hec.ENTITY_GROUP_ID =heg.entity_group_id and
599: hec.entity_id = hte1.TIME_ENTRY_RULE_ID and