APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TIME_ENTRY_RULES

Line 4685: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;

4681: l_day_ovn number;
4682: l_time_recipient varchar2(150);
4683: l_tc_start_time date;
4684: l_tc_stop_time date;
4685: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;
4686: --
4687: l_cnt number;
4688: -- l_item_key wf_items.item_key%type;
4689: l_current_rule varchar2(1000);

Line 5110: ,hxc_time_entry_rules dar

5106: ,dar.attribute15
5107: ,ff.formula_name
5108: ,''
5109: from ff_formulas_f ff
5110: ,hxc_time_entry_rules dar
5111: where dar.time_entry_rule_id = p_data_appr_rule_id
5112: and p_end_date between dar.start_date and dar.end_date
5113: and ff.formula_id(+) = dar.formula_id
5114: and dar.start_date BETWEEN ff.effective_start_date(+)

Line 5124: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;

5120: FROM hxc_time_building_blocks
5121: WHERE time_building_block_id = p_bb_id
5122: AND object_version_number = p_bb_ovn;
5123: --
5124: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;
5125: l_rule_usage hxc_time_entry_rules.rule_usage%type;
5126: l_formula_id hxc_time_entry_rules.formula_id%type;
5127: l_tc_start_date date;
5128: l_tc_end_date date;

Line 5125: l_rule_usage hxc_time_entry_rules.rule_usage%type;

5121: WHERE time_building_block_id = p_bb_id
5122: AND object_version_number = p_bb_ovn;
5123: --
5124: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;
5125: l_rule_usage hxc_time_entry_rules.rule_usage%type;
5126: l_formula_id hxc_time_entry_rules.formula_id%type;
5127: l_tc_start_date date;
5128: l_tc_end_date date;
5129: --

Line 5126: l_formula_id hxc_time_entry_rules.formula_id%type;

5122: AND object_version_number = p_bb_ovn;
5123: --
5124: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;
5125: l_rule_usage hxc_time_entry_rules.rule_usage%type;
5126: l_formula_id hxc_time_entry_rules.formula_id%type;
5127: l_tc_start_date date;
5128: l_tc_end_date date;
5129: --
5130: l_app_start_date date;

Line 5138: l_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype;

5134: l_tc_ovn number;
5135: l_current_rule varchar2(1000);
5136: l_all_rules varchar2(1000);
5137: --
5138: l_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype;
5139: l_outputs ff_exec.outputs_t;
5140: l_result varchar2(1000);
5141: --
5142: l_error_table hxc_self_service_time_deposit.message_table;