APPS.PA_PURGE_UNASGN_FI dependencies on DUAL

Line 54: select pa_purge_batches_s.nextval into l_purge_batch_id from dual;

50:
51: arpr_log(' About to purge unassigned time forecast items ') ;
52: x_err_stage := 'About to start purge unassigned time forecast items' ;
53:
54: select pa_purge_batches_s.nextval into l_purge_batch_id from dual;
55:
56: arpr_log(' l_purge_batch_id: '||l_purge_batch_id);
57:
58: OPEN CUR_forecast_items;

Line 833: FROM DUAL;

829: AND lookup_code = 'PA_R_UNASS_TIME_01';
830:
831: SELECT rpad(l_sob_name,30,' ')||lpad(l_tmp_str,75,' ')||sysdate
832: INTO l_tblock
833: FROM DUAL;
834:
835: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
836: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
837:

Line 846: FROM DUAL;

842: AND lookup_code = 'PA_R_UNASS_TIME_02';
843:
844: SELECT lpad(l_tmp_str,66+length(l_tmp_str)/2,' ')
845: INTO l_tblock
846: FROM DUAL;
847:
848: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
849: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
850:

Line 892: FROM DUAL;

888: AND lookup_code = 'PA_R_UNASS_TIME_07';
889:
890: SELECT l_tmp_str||' '||l_tmp_str2||l_tmp_str3
891: INTO l_tblock
892: FROM DUAL;
893:
894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tblock);
895:
896: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 904: FROM DUAL;

900:
901: SELECT ' '||rpad(i.table_name,30,' ')||lpad(i.num_recs_archived,26,' ')||' '||lpad(i.num_recs_purged,24,' ')
902: INTO
903: l_tmp_str
904: FROM DUAL;
905:
906: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str);
907:
908: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);