APPS.HXC_LOAD_PKG dependencies on HXC_TIME_ENTRY_RULES

Line 31: , hxc_time_entry_rules ter

27: CURSOR csr_chk_ref_integ ( p_time_category_id NUMBER ) IS
28: SELECT DISTINCT ter.time_entry_rule_id
29: , dfcu.application_column_name
30: FROM fnd_descr_flex_column_usages dfcu
31: , hxc_time_entry_rules ter
32: WHERE ter.formula_id IS NOT NULL
33: AND
34: dfcu.application_id = 809 AND
35: dfcu.descriptive_flex_context_code = ter.attribute_category AND

Line 72: TYPE r_ter_record IS RECORD ( ter_id hxc_time_entry_rules.time_entry_rule_id%TYPE

68: 'ATTRIBUTE30', ter.attribute30, 'zZz' ) = TO_CHAR(p_time_category_id);
69:
70:
71:
72: TYPE r_ter_record IS RECORD ( ter_id hxc_time_entry_rules.time_entry_rule_id%TYPE
73: ,attribute varchar2(20) );
74:
75: TYPE t_ter_table IS TABLE OF r_ter_record INDEX BY BINARY_INTEGER;
76: FUNCTION get_tc_ref_integrity_list ( p_time_category_id NUMBER ) RETURN t_ter_table;