DBA Data[Home] [Help]

APPS.PAY_SE_EXPIRY_SUPPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 174: FROM pay_assignment_actions

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

Line 180: FROM pay_assignment_actions paa, per_all_assignments_f paf

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: