DBA Data[Home] [Help]

APPS.HXT_TIM_COL_UTIL dependencies on HXT_EARNING_POLICIES

Line 109: FROM hxt_earning_policies

105: IF i_earn_pol_name IS NOT NULL THEN
106: /* Earning Policy override from API parameters. */
107: SELECT id
108: INTO o_earn_pol_id
109: FROM hxt_earning_policies
110: WHERE name = i_earn_pol_name
111: AND i_date_worked BETWEEN effective_start_date
112: AND effective_end_date;
113: ELSIF i_assignment_id IS NOT NULL THEN

Line 117: FROM hxt_earning_policies ep,

113: ELSIF i_assignment_id IS NOT NULL THEN
114: /* No Earning Policy override, get EP for current assignment. */
115: SELECT ep.id
116: INTO o_earn_pol_id
117: FROM hxt_earning_policies ep,
118: hxt_per_aei_ddf_v pafv
119: WHERE pafv.assignment_id = i_assignment_id
120: AND i_date_worked BETWEEN pafv.effective_start_date
121: AND pafv.effective_end_date