APPS.HXT_TIME_COLLECTION dependencies on HXT_EARNING_POLICIES

Line 6046: l_tc_intvl hxt_earning_policies.min_tcard_intvl%TYPE;

6042: p_actual_time_in IN OUT NOCOPY DATE,
6043: p_actual_time_out IN OUT NOCOPY DATE
6044: )
6045: IS
6046: l_tc_intvl hxt_earning_policies.min_tcard_intvl%TYPE;
6047: l_round_up hxt_earning_policies.round_up%TYPE;
6048: l_rot_id hxt_rotation_plans.ID%TYPE;
6049: l_work_id hxt_rotation_schedules.tws_id%TYPE;
6050: l_osp_id NUMBER;

Line 6047: l_round_up hxt_earning_policies.round_up%TYPE;

6043: p_actual_time_out IN OUT NOCOPY DATE
6044: )
6045: IS
6046: l_tc_intvl hxt_earning_policies.min_tcard_intvl%TYPE;
6047: l_round_up hxt_earning_policies.round_up%TYPE;
6048: l_rot_id hxt_rotation_plans.ID%TYPE;
6049: l_work_id hxt_rotation_schedules.tws_id%TYPE;
6050: l_osp_id NUMBER;
6051: l_sdf_id NUMBER;

Line 6567: FROM hxt_earning_policies

6563: END IF;
6564:
6565: SELECT min_tcard_intvl, round_up
6566: INTO l_tc_intvl, l_round_up
6567: FROM hxt_earning_policies
6568: WHERE ID = p_earn_pol_id;
6569:
6570: IF g_debug
6571: THEN