DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_DATA_APP_RULE_USAGES

Line 4667: from hxc_data_app_rule_usages dru

4663: --
4664: cursor csr_get_appr_rule_id(p_appr_style_id number,
4665: p_time_recipient_id varchar2) is
4666: select dru.time_entry_rule_id
4667: from hxc_data_app_rule_usages dru
4668: where dru.approval_style_id = p_appr_style_id
4669: and to_char(dru.time_recipient_id) = p_time_recipient_id;
4670: --
4671: -- l_tc_bld_blk_id number;

Line 4679: l_tc_appr_style_id hxc_data_app_rule_usages.approval_style_id%type;

4675: l_tc_date_from date;
4676: l_tc_date_to date;
4677: --
4678: l_tc_resource_id number;
4679: l_tc_appr_style_id hxc_data_app_rule_usages.approval_style_id%type;
4680: l_day_bb_id number;
4681: l_day_ovn number;
4682: l_time_recipient varchar2(150);
4683: l_tc_start_time date;