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 1425: from dual);

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