APPS.HXC_TER_UPLOAD_PKG dependencies on HXC_TIME_RECIPIENTS

Line 82: l_tr_id hxc_time_recipients.time_recipient_id%TYPE;

78: END get_ff_id;
79:
80: FUNCTION get_app_id ( p_time_recipient_name VARCHAR2 ) RETURN NUMBER IS
81:
82: l_tr_id hxc_time_recipients.time_recipient_id%TYPE;
83:
84: CURSOR csr_get_app_id IS
85: SELECT tr.time_recipient_id
86: FROM hxc_time_recipients tr

Line 86: FROM hxc_time_recipients tr

82: l_tr_id hxc_time_recipients.time_recipient_id%TYPE;
83:
84: CURSOR csr_get_app_id IS
85: SELECT tr.time_recipient_id
86: FROM hxc_time_recipients tr
87: WHERE tr.name = p_time_recipient_name;
88:
89: BEGIN
90:

Line 282: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;

278:
279: l_data_app_rule_usage_id hxc_data_app_rule_usages.data_app_rule_usage_id%TYPE;
280: l_time_entry_rule_id hxc_data_app_rule_usages.time_entry_rule_id%TYPE;
281: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
282: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
283: l_ovn hxc_deposit_processes.object_version_number%TYPE;
284: l_owner VARCHAR2(6);
285:
286: FUNCTION get_time_entry_rule_id ( p_time_entry_rule_name VARCHAR2 ) RETURN NUMBER IS