APPS.PSP_SUM_ADJ dependencies on PSP_SUMMARY_LINES_S

Line 1080: SELECT PSP_SUMMARY_LINES_S.NEXTVAL

1076: END IF;
1077: -- Code ended for Enhancement Employee Assignment with Zero Work Days
1078:
1079:
1080: SELECT PSP_SUMMARY_LINES_S.NEXTVAL
1081: INTO P_SUMMARY_LINE_ID
1082: FROM DUAL;
1083:
1084: INSERT INTO PSP_SUMMARY_LINES(

Line 3489: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated psp_summary_lines set gms_batch_name to '||l_gms_stat_batch_name||' for STAT records count: '||sql%rowcount);

3485: and currency_code = 'STAT')
3486: AND gms_batch_name = l_gms_batch_name
3487: AND status_code = 'N'
3488: AND gl_code_combination_id IS NULL;
3489: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated psp_summary_lines set gms_batch_name to '||l_gms_stat_batch_name||' for STAT records count: '||sql%rowcount);
3490:
3491:
3492:
3493: SELECT count(*) INTO l_not_stat_count