APPS.PA_PURGE_UNASGN_FI dependencies on PA_LOOKUPS

Line 827: FROM PA_LOOKUPS

823: WHERE GL.Set_Of_Books_ID = l_sob_id;
824:
825: SELECT meaning
826: INTO l_tmp_str
827: FROM PA_LOOKUPS
828: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
829: AND lookup_code = 'PA_R_UNASS_TIME_01';
830:
831: SELECT rpad(l_sob_name,30,' ')||lpad(l_tmp_str,75,' ')||sysdate

Line 840: FROM PA_LOOKUPS

836: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
837:
838: SELECT meaning
839: INTO l_tmp_str
840: FROM PA_LOOKUPS
841: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
842: AND lookup_code = 'PA_R_UNASS_TIME_02';
843:
844: SELECT lpad(l_tmp_str,66+length(l_tmp_str)/2,' ')

Line 853: FROM PA_LOOKUPS

849: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
850:
851: SELECT lpad(meaning,32,' ')
852: INTO l_tmp_str
853: FROM PA_LOOKUPS
854: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
855: AND lookup_code = 'PA_R_UNASS_TIME_03';
856:
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str||p_archive_flag);

Line 862: FROM PA_LOOKUPS

858: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
859:
860: SELECT lpad(meaning,32,' ')
861: INTO l_tmp_str
862: FROM PA_LOOKUPS
863: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
864: AND lookup_code = 'PA_R_UNASS_TIME_04';
865:
866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str||p_txn_to_date);

Line 874: FROM PA_LOOKUPS

870: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
871:
872: SELECT ' '||rpad(meaning,20,' ')
873: INTO l_tmp_str
874: FROM PA_LOOKUPS
875: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
876: AND lookup_code = 'PA_R_UNASS_TIME_05';
877:
878: SELECT rpad(meaning,52,' ')

Line 880: FROM PA_LOOKUPS

876: AND lookup_code = 'PA_R_UNASS_TIME_05';
877:
878: SELECT rpad(meaning,52,' ')
879: INTO l_tmp_str2
880: FROM PA_LOOKUPS
881: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
882: AND lookup_code = 'PA_R_UNASS_TIME_06';
883:
884: SELECT rpad(meaning,48,' ')

Line 886: FROM PA_LOOKUPS

882: AND lookup_code = 'PA_R_UNASS_TIME_06';
883:
884: SELECT rpad(meaning,48,' ')
885: INTO l_tmp_str3
886: FROM PA_LOOKUPS
887: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
888: AND lookup_code = 'PA_R_UNASS_TIME_07';
889:
890: SELECT l_tmp_str||' '||l_tmp_str2||l_tmp_str3