APPS.HXT_UTIL dependencies on HXT_DET_HOURS_WORKED_F

Line 734: hxt_det_hours_worked_f hdh,

730: --
731: cursor csr_retro_end IS
732: select ptp.end_date
733: from per_time_periods ptp,
734: hxt_det_hours_worked_f hdh,
735: hxt_timecards_f htf
736: where hdh.retro_batch_id = p_batch_id
737: and hdh.tim_id = htf.id
738: and htf.time_period_id = ptp.time_period_id;

Line 1779: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f

1775:
1776: cursor get_max_retro_batch is
1777: select max(batch_id) from pay_batch_headers pbh
1778: where pbh.batch_status='T'
1779: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f
1780: where tim_id=p_tim_id);
1781:
1782:
1783: cursor chk_retro_batch_status is

Line 1786: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f

1782:
1783: cursor chk_retro_batch_status is
1784: select batch_id from pay_batch_headers pbh
1785: where pbh.batch_status='T'
1786: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f
1787: where tim_id=p_tim_id);
1788:
1789:
1790: cursor chk_original_batch_status is

Line 1802: FROM hxt_det_hours_worked_f det,

1798: p_accrual_plan_id NUMBER,
1799: p_bus_group_id NUMBER,
1800: p_batch_id number) is
1801: SELECT nvl(sum(det.hours*(-1)*(ncr.add_or_subtract)),0)
1802: FROM hxt_det_hours_worked_f det,
1803: pay_net_calculation_rules_v ncr
1804: WHERE det.tim_id = p_tim_id
1805: AND det.assignment_id = p_assignment_id
1806: AND ncr.business_group_id = p_bus_group_id

Line 1816: FROM hxt_det_hours_worked_f det,

1812: p_assignment_id NUMBER,
1813: p_accrual_plan_id NUMBER,
1814: p_bus_group_id NUMBER) is
1815: SELECT nvl(sum(det.hours*(-1)*(ncr.add_or_subtract)),0)
1816: FROM hxt_det_hours_worked_f det,
1817: pay_net_calculation_rules_v ncr
1818: WHERE det.tim_id = p_tim_id
1819: AND det.assignment_id = p_assignment_id
1820: AND ncr.business_group_id = p_bus_group_id

Line 2262: FROM hxt_det_hours_worked_f hdhw

2258: FROM hxt_timecards_f HTF
2259: WHERE HTF.batch_id = pbh.batch_id)
2260: UNION
2261: (SELECT hdhw.retro_batch_id
2262: FROM hxt_det_hours_worked_f hdhw
2263: WHERE hdhw.retro_batch_id = pbh.batch_id));
2264: l_dummy VARCHAR2 (1);
2265: BEGIN
2266: g_debug :=hr_utility.debug_enabled;

Line 2319: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,

2315:
2316: END get_week_day;
2317:
2318: FUNCTION is_valid_time_entry (
2319: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2320: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2321: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
2322: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
2323: )

Line 2320: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,

2316: END get_week_day;
2317:
2318: FUNCTION is_valid_time_entry (
2319: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2320: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2321: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
2322: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
2323: )
2324: RETURN BOOLEAN AS

Line 2321: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,

2317:
2318: FUNCTION is_valid_time_entry (
2319: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2320: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2321: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
2322: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
2323: )
2324: RETURN BOOLEAN AS
2325:

Line 2322: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE

2318: FUNCTION is_valid_time_entry (
2319: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2320: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
2321: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
2322: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
2323: )
2324: RETURN BOOLEAN AS
2325:
2326: l_proc VARCHAR2 (30) ;