DBA Data[Home] [Help]

APPS.PSP_CREATE_EFF_REPORTS dependencies on DUAL

Line 37: select pay_assignment_actions_s.nextval into l_asgactid from dual;

33: FOR i in 1..person_array.person_id.count
34:
35: LOOP
36:
37: select pay_assignment_actions_s.nextval into l_asgactid from dual;
38:
39: hr_nonrun_asact.insact( l_asgactid ,
40: pactid => p_pactid,
41: chunk => p_chunk_num,

Line 1423: from dual);

1419: source_id, error_message, retry_request_id, pdf_request_id,
1420: source_name, parent_source_id, parent_source_name)
1421: (select psp_report_errors_s.nextval , p_request_id,
1422: 'W', skipped_asg_rec.person_id , l_msg_str , p_retry_request_id, null, NULL, NULL, null
1423: from dual);
1424:
1425: end loop;
1426:
1427: end if;