APPS.HXC_SETUP_VALIDATION_PKG dependencies on HXC_TIME_ENTRY_RULES

Line 116: INDEX(hte hxc_time_entry_rules_pk)*/

112:
113: CURSOR csr_get_elp_terg_comps(p_elp_terg_id number,
114: p_time_recipient_id number) IS
115: SELECT /*+ ORDERED
116: INDEX(hte hxc_time_entry_rules_pk)*/
117: 'Y'
118: FROM hxc_entity_groups heg,
119: hxc_entity_group_comps hec,
120: hxc_time_entry_rules hte

Line 120: hxc_time_entry_rules hte

116: INDEX(hte hxc_time_entry_rules_pk)*/
117: 'Y'
118: FROM hxc_entity_groups heg,
119: hxc_entity_group_comps hec,
120: hxc_time_entry_rules hte
121: WHERE heg.entity_type = 'TIME_ENTRY_RULES' and
122: heg.entity_group_id = p_elp_terg_id and
123: hec.ENTITY_GROUP_ID =heg.entity_group_id and
124: hec.entity_id = hte.TIME_ENTRY_RULE_ID and

Line 176: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;

172:
173: l_rtr_tr_id hxc_time_recipients.time_recipient_id%TYPE;
174: l_aps_tr_id hxc_time_recipients.time_recipient_id%TYPE;
175:
176: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
177:
178: -- OTL - ABS Integration
179: l_absences_integration VARCHAR2(5);
180: l_mismatch_abs BOOLEAN := FALSE;

Line 930: hxc_time_entry_rules_utils_pkg.tc_edit_allowed

926:
927: IF (to_char(l_timecard_info_rec.start_date,'YYYY/MM/DD') <= l_futur_limit_date and
928: to_char(l_timecard_info_rec.end_date,'YYYY/MM/DD') >= l_past_limit_date )
929: THEN
930: hxc_time_entry_rules_utils_pkg.tc_edit_allowed
931: (p_timecard_id => l_timecard_info_rec.timecard_bb_id
932: ,p_timecard_ovn => l_timecard_info_rec.timecard_ovn
933: ,p_timecard_status => l_tc_approval_status
934: ,p_edit_allowed_preference => l_status_allowing_edits