APPS.PSA_BC_XML_REPORT_PUB dependencies on GL_LOOKUPS

Line 2809: FROM gl_lookups

2805:
2806: IF l_document_status IS NOT NULL THEN
2807:
2808: SELECT description into l_meaning
2809: FROM gl_lookups
2810: WHERE lookup_type = 'FUNDS_CHECK_STATUS_CODE' and
2811: lookup_code = l_document_status;
2812:
2813: END IF;

Line 2831: FROM gl_lookups

2827: -- Bug 5713831, Added statement below to update lookup values
2828:
2829: UPDATE psa_bc_results_gt rg
2830: SET actual_flag_meaning = (SELECT description
2831: FROM gl_lookups
2832: WHERE lookup_code = rg.actual_flag
2833: AND lookup_type = 'BATCH_TYPE');
2834:
2835: UPDATE psa_bc_results_gt rg

Line 2837: FROM gl_lookups

2833: AND lookup_type = 'BATCH_TYPE');
2834:
2835: UPDATE psa_bc_results_gt rg
2836: SET funds_check_status = nvl((SELECT meaning
2837: FROM gl_lookups
2838: WHERE lookup_code = rg.funds_check_status_code
2839: AND lookup_type = 'FUNDS_CHECK_STATUS_CODE'),
2840: decode(rg.funds_check_status_code, 'Z', 'Accounting could not be created', ' ')) ;
2841:

Line 2844: FROM gl_lookups

2840: decode(rg.funds_check_status_code, 'Z', 'Accounting could not be created', ' ')) ;
2841:
2842: UPDATE psa_bc_results_gt rg
2843: SET result_message = (SELECT description
2844: FROM gl_lookups
2845: WHERE lookup_code = rg.result_code
2846: AND lookup_type = 'FUNDS_CHECK_RESULT_CODE')
2847: WHERE result_message IS NULL;
2848:

Line 2851: FROM gl_lookups

2847: WHERE result_message IS NULL;
2848:
2849: UPDATE psa_bc_results_gt rg
2850: SET amount_type_meaning = (SELECT meaning
2851: FROM gl_lookups
2852: WHERE lookup_code = rg.amount_type
2853: AND lookup_type = 'PTD_YTD');
2854:
2855: UPDATE psa_bc_results_gt rg

Line 2857: FROM gl_lookups

2853: AND lookup_type = 'PTD_YTD');
2854:
2855: UPDATE psa_bc_results_gt rg
2856: SET boundary = (SELECT meaning
2857: FROM gl_lookups
2858: WHERE lookup_code = rg.boundary_code
2859: AND lookup_type = 'BOUNDARY_TYPE');
2860:
2861: UPDATE psa_bc_results_gt rg

Line 2863: FROM gl_lookups

2859: AND lookup_type = 'BOUNDARY_TYPE');
2860:
2861: UPDATE psa_bc_results_gt rg
2862: SET funds_check_level_meaning = (SELECT meaning
2863: FROM gl_lookups
2864: WHERE lookup_code = rg.funds_check_level_code
2865: AND lookup_type = 'FUNDS_CHECK_LEVEL');
2866:
2867: UPDATE psa_bc_results_gt rg

Line 2869: FROM gl_lookups

2865: AND lookup_type = 'FUNDS_CHECK_LEVEL');
2866:
2867: UPDATE psa_bc_results_gt rg
2868: SET account_type_meaning = (SELECT description
2869: FROM gl_lookups
2870: WHERE lookup_code = rg.account_type
2871: AND lookup_type = 'ACCOUNT TYPE');
2872:
2873: -- End Bug 5713831