APPS.PAY_SE_ARCHIVE_TETA dependencies on PAY_ASSIGNMENT_ACTIONS

Line 312: SELECT pay_assignment_actions_s.NEXTVAL

308: LOOP
309:
310: --fnd_file.put_line(fnd_file.log,'Assignment Action Code Loop');
311:
312: SELECT pay_assignment_actions_s.NEXTVAL
313: INTO l_actid
314: FROM dual;
315: --
316: g_index_assact := g_index_assact + 1;

Line 474: FROM pay_assignment_actions paa

470: /*Cursor for fetching assignment_id*/
471: CURSOR csr_assign_id
472: IS
473: SELECT paa.assignment_id
474: FROM pay_assignment_actions paa
475: WHERE paa.assignment_action_id = p_assignment_action_id;
476:
477: l_action_context_id NUMBER;
478: l_flag NUMBER := 0;