APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TIME_ENTRY_RULES

Line 5372: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;

5368: l_day_ovn number;
5369: l_time_recipient varchar2(150);
5370: l_tc_start_time date;
5371: l_tc_stop_time date;
5372: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;
5373: --
5374: l_cnt number;
5375: -- l_item_key wf_items.item_key%type;
5376: l_current_rule varchar2(1000);

Line 5797: ,hxc_time_entry_rules dar

5793: ,dar.attribute15
5794: ,ff.formula_name
5795: ,''
5796: from ff_formulas_f ff
5797: ,hxc_time_entry_rules dar
5798: where dar.time_entry_rule_id = p_data_appr_rule_id
5799: and p_end_date between dar.start_date and dar.end_date
5800: and ff.formula_id(+) = dar.formula_id
5801: and dar.start_date BETWEEN ff.effective_start_date(+)

Line 5811: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;

5807: FROM hxc_time_building_blocks
5808: WHERE time_building_block_id = p_bb_id
5809: AND object_version_number = p_bb_ovn;
5810: --
5811: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;
5812: l_rule_usage hxc_time_entry_rules.rule_usage%type;
5813: l_formula_id hxc_time_entry_rules.formula_id%type;
5814: l_tc_start_date date;
5815: l_tc_end_date date;

Line 5812: l_rule_usage hxc_time_entry_rules.rule_usage%type;

5808: WHERE time_building_block_id = p_bb_id
5809: AND object_version_number = p_bb_ovn;
5810: --
5811: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;
5812: l_rule_usage hxc_time_entry_rules.rule_usage%type;
5813: l_formula_id hxc_time_entry_rules.formula_id%type;
5814: l_tc_start_date date;
5815: l_tc_end_date date;
5816: --

Line 5813: l_formula_id hxc_time_entry_rules.formula_id%type;

5809: AND object_version_number = p_bb_ovn;
5810: --
5811: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;
5812: l_rule_usage hxc_time_entry_rules.rule_usage%type;
5813: l_formula_id hxc_time_entry_rules.formula_id%type;
5814: l_tc_start_date date;
5815: l_tc_end_date date;
5816: --
5817: l_app_start_date date;

Line 5825: l_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype;

5821: l_tc_ovn number;
5822: l_current_rule varchar2(1000);
5823: l_all_rules varchar2(1000);
5824: --
5825: l_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype;
5826: l_outputs ff_exec.outputs_t;
5827: l_result varchar2(1000);
5828: --
5829: l_error_table hxc_self_service_time_deposit.message_table;