APPS.PA_PURGE_UNASGN_FI dependencies on PA_LOOKUPS

Line 815: FROM PA_LOOKUPS

811: WHERE GL.Set_Of_Books_ID = l_sob_id;
812:
813: SELECT meaning
814: INTO l_tmp_str
815: FROM PA_LOOKUPS
816: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
817: AND lookup_code = 'PA_R_UNASS_TIME_01';
818:
819: SELECT rpad(l_sob_name,30,' ')||lpad(l_tmp_str,75,' ')||sysdate

Line 828: FROM PA_LOOKUPS

824: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
825:
826: SELECT meaning
827: INTO l_tmp_str
828: FROM PA_LOOKUPS
829: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
830: AND lookup_code = 'PA_R_UNASS_TIME_02';
831:
832: SELECT lpad(l_tmp_str,66+length(l_tmp_str)/2,' ')

Line 841: FROM PA_LOOKUPS

837: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
838:
839: SELECT lpad(meaning,32,' ')
840: INTO l_tmp_str
841: FROM PA_LOOKUPS
842: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
843: AND lookup_code = 'PA_R_UNASS_TIME_03';
844:
845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str||p_archive_flag);

Line 850: FROM PA_LOOKUPS

846: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
847:
848: SELECT lpad(meaning,32,' ')
849: INTO l_tmp_str
850: FROM PA_LOOKUPS
851: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
852: AND lookup_code = 'PA_R_UNASS_TIME_04';
853:
854: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str||p_txn_to_date);

Line 862: FROM PA_LOOKUPS

858: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
859:
860: SELECT ' '||rpad(meaning,20,' ')
861: INTO l_tmp_str
862: FROM PA_LOOKUPS
863: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
864: AND lookup_code = 'PA_R_UNASS_TIME_05';
865:
866: SELECT rpad(meaning,52,' ')

Line 868: FROM PA_LOOKUPS

864: AND lookup_code = 'PA_R_UNASS_TIME_05';
865:
866: SELECT rpad(meaning,52,' ')
867: INTO l_tmp_str2
868: FROM PA_LOOKUPS
869: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
870: AND lookup_code = 'PA_R_UNASS_TIME_06';
871:
872: SELECT rpad(meaning,48,' ')

Line 874: FROM PA_LOOKUPS

870: AND lookup_code = 'PA_R_UNASS_TIME_06';
871:
872: SELECT rpad(meaning,48,' ')
873: INTO l_tmp_str3
874: FROM PA_LOOKUPS
875: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
876: AND lookup_code = 'PA_R_UNASS_TIME_07';
877:
878: SELECT l_tmp_str||' '||l_tmp_str2||l_tmp_str3