2721:
2722: IF l_document_status IS NOT NULL THEN
2723:
2724: SELECT description into l_meaning
2725: FROM gl_lookups
2726: WHERE lookup_type = 'FUNDS_CHECK_STATUS_CODE' and
2727: lookup_code = l_document_status;
2728:
2729: END IF;
2743: -- Bug 5713831, Added statement below to update lookup values
2744:
2745: UPDATE psa_bc_results_gt rg
2746: SET actual_flag_meaning = (SELECT description
2747: FROM gl_lookups
2748: WHERE lookup_code = rg.actual_flag
2749: AND lookup_type = 'BATCH_TYPE');
2750:
2751: UPDATE psa_bc_results_gt rg
2749: AND lookup_type = 'BATCH_TYPE');
2750:
2751: UPDATE psa_bc_results_gt rg
2752: SET funds_check_status = (SELECT meaning
2753: FROM gl_lookups
2754: WHERE lookup_code = rg.funds_check_status_code
2755: AND lookup_type = 'FUNDS_CHECK_STATUS_CODE');
2756:
2757: UPDATE psa_bc_results_gt rg
2755: AND lookup_type = 'FUNDS_CHECK_STATUS_CODE');
2756:
2757: UPDATE psa_bc_results_gt rg
2758: SET result_message = (SELECT description
2759: FROM gl_lookups
2760: WHERE lookup_code = rg.result_code
2761: AND lookup_type = 'FUNDS_CHECK_RESULT_CODE')
2762: WHERE result_message IS NULL;
2763:
2762: WHERE result_message IS NULL;
2763:
2764: UPDATE psa_bc_results_gt rg
2765: SET amount_type_meaning = (SELECT meaning
2766: FROM gl_lookups
2767: WHERE lookup_code = rg.amount_type
2768: AND lookup_type = 'PTD_YTD');
2769:
2770: UPDATE psa_bc_results_gt rg
2768: AND lookup_type = 'PTD_YTD');
2769:
2770: UPDATE psa_bc_results_gt rg
2771: SET boundary = (SELECT meaning
2772: FROM gl_lookups
2773: WHERE lookup_code = rg.boundary_code
2774: AND lookup_type = 'BOUNDARY_TYPE');
2775:
2776: UPDATE psa_bc_results_gt rg
2774: AND lookup_type = 'BOUNDARY_TYPE');
2775:
2776: UPDATE psa_bc_results_gt rg
2777: SET funds_check_level_meaning = (SELECT meaning
2778: FROM gl_lookups
2779: WHERE lookup_code = rg.funds_check_level_code
2780: AND lookup_type = 'FUNDS_CHECK_LEVEL');
2781:
2782: UPDATE psa_bc_results_gt rg
2780: AND lookup_type = 'FUNDS_CHECK_LEVEL');
2781:
2782: UPDATE psa_bc_results_gt rg
2783: SET account_type_meaning = (SELECT description
2784: FROM gl_lookups
2785: WHERE lookup_code = rg.account_type
2786: AND lookup_type = 'ACCOUNT TYPE');
2787:
2788: -- End Bug 5713831