593: l_sys_date_time VARCHAR2(40);
594: l_tag VARCHAR2(1000);
595: l_procedure VARCHAR2(100) ;
596:
597: l_bank_name FND_COMMON_LOOKUPS.MEANING%TYPE ;
598: l_base_branch_name FND_COMMON_LOOKUPS.MEANING%TYPE ;
599:
600: CURSOR csr_challan
601: IS
594: l_tag VARCHAR2(1000);
595: l_procedure VARCHAR2(100) ;
596:
597: l_bank_name FND_COMMON_LOOKUPS.MEANING%TYPE ;
598: l_base_branch_name FND_COMMON_LOOKUPS.MEANING%TYPE ;
599:
600: CURSOR csr_challan
601: IS
602: SELECT DISTINCT