APPS.HXT_TIME_COLLECTION dependencies on HXT_EARNING_POLICIES

Line 6427: l_tc_intvl hxt_earning_policies.min_tcard_intvl%TYPE;

6423: p_actual_time_in IN OUT NOCOPY DATE,
6424: p_actual_time_out IN OUT NOCOPY DATE
6425: )
6426: IS
6427: l_tc_intvl hxt_earning_policies.min_tcard_intvl%TYPE;
6428: l_round_up hxt_earning_policies.round_up%TYPE;
6429: l_rot_id hxt_rotation_plans.ID%TYPE;
6430: l_work_id hxt_rotation_schedules.tws_id%TYPE;
6431: l_osp_id NUMBER;

Line 6428: l_round_up hxt_earning_policies.round_up%TYPE;

6424: p_actual_time_out IN OUT NOCOPY DATE
6425: )
6426: IS
6427: l_tc_intvl hxt_earning_policies.min_tcard_intvl%TYPE;
6428: l_round_up hxt_earning_policies.round_up%TYPE;
6429: l_rot_id hxt_rotation_plans.ID%TYPE;
6430: l_work_id hxt_rotation_schedules.tws_id%TYPE;
6431: l_osp_id NUMBER;
6432: l_sdf_id NUMBER;

Line 6948: FROM hxt_earning_policies

6944: END IF;
6945:
6946: SELECT min_tcard_intvl, round_up
6947: INTO l_tc_intvl, l_round_up
6948: FROM hxt_earning_policies
6949: WHERE ID = p_earn_pol_id;
6950:
6951: IF g_debug
6952: THEN