APPS.HXC_SETUP_VALIDATION_PKG dependencies on HXC_TIME_RECIPIENTS

Line 173: l_rtr_tr_id hxc_time_recipients.time_recipient_id%TYPE;

169:
170: l_status_allowing_edits hxc_pref_hierarchies.attribute1%TYPE;
171: l_edit_allowed VARCHAR2(5);
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:

Line 174: l_aps_tr_id hxc_time_recipients.time_recipient_id%TYPE;

170: l_status_allowing_edits hxc_pref_hierarchies.attribute1%TYPE;
171: l_edit_allowed VARCHAR2(5);
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

Line 475: FROM hxc_time_recipients

471: EXIT WHEN csr_get_app_sets%NOTFOUND OR l_pay_tr_exists > 0;
472:
473: SELECT COUNT(1)
474: INTO l_pay_tr_exists
475: FROM hxc_time_recipients
476: WHERE time_recipient_id = l_aps_tr_id
477: AND application_id = 801; -- Payroll
478:
479: END LOOP;