170:
171: /*
172: CURSOR csr_assignment IS
173: SELECT assignment_id
174: FROM pay_assignment_actions
175: WHERE assignment_action_id=p_assignment_action_id;
176: */
177: /* 9761058 start */
178: CURSOR csr_assignment IS
176: */
177: /* 9761058 start */
178: CURSOR csr_assignment IS
179: SELECT paf.assignment_id, paf.business_group_id
180: FROM pay_assignment_actions paa, per_all_assignments_f paf
181: WHERE paa.assignment_action_id=p_assignment_action_id
182: AND paa.assignment_id=paf.assignment_id
183: AND p_effective_date BETWEEN paf.EFFECTIVE_START_DATE AND paf.EFFECTIVE_END_DATE ;
184: