APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_DATA_APP_RULE_USAGES

Line 5354: from hxc_data_app_rule_usages dru

5350: --
5351: cursor csr_get_appr_rule_id(p_appr_style_id number,
5352: p_time_recipient_id varchar2) is
5353: select dru.time_entry_rule_id
5354: from hxc_data_app_rule_usages dru
5355: where dru.approval_style_id = p_appr_style_id
5356: and to_char(dru.time_recipient_id) = p_time_recipient_id;
5357: --
5358: -- l_tc_bld_blk_id number;

Line 5366: l_tc_appr_style_id hxc_data_app_rule_usages.approval_style_id%type;

5362: l_tc_date_from date;
5363: l_tc_date_to date;
5364: --
5365: l_tc_resource_id number;
5366: l_tc_appr_style_id hxc_data_app_rule_usages.approval_style_id%type;
5367: l_day_bb_id number;
5368: l_day_ovn number;
5369: l_time_recipient varchar2(150);
5370: l_tc_start_time date;