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
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