APPS.PSA_BC_XML_REPORT_PUB dependencies on PSA_LOOKUP_CODES

Line 3049: l_funds_check_status PSA_LOOKUP_CODES.meaning%TYPE;

3045: l_api_name VARCHAR2(240);
3046: l_para_meaning_list VARCHAR2(2000);
3047: l_ledger_name GL_LEDGERS.name%TYPE;
3048: l_application_short_name VARCHAR2(8);
3049: l_funds_check_status PSA_LOOKUP_CODES.meaning%TYPE;
3050: l_funds_check_order_by PSA_LOOKUP_CODES.meaning%TYPE;
3051: l_offset INTEGER;
3052:
3053: BEGIN

Line 3050: l_funds_check_order_by PSA_LOOKUP_CODES.meaning%TYPE;

3046: l_para_meaning_list VARCHAR2(2000);
3047: l_ledger_name GL_LEDGERS.name%TYPE;
3048: l_application_short_name VARCHAR2(8);
3049: l_funds_check_status PSA_LOOKUP_CODES.meaning%TYPE;
3050: l_funds_check_order_by PSA_LOOKUP_CODES.meaning%TYPE;
3051: l_offset INTEGER;
3052:
3053: BEGIN
3054: l_api_name := g_full_path||'construct_bc_report_output';

Line 3076: FROM PSA_LOOKUP_CODES

3072: END IF;
3073: IF p_para_rec.bc_funds_check_status IS NOT NULL THEN
3074: SELECT meaning
3075: INTO l_funds_check_status
3076: FROM PSA_LOOKUP_CODES
3077: WHERE lookup_type = 'PSA_BC_FUNDS_CHECK_STATUS'
3078: AND lookup_code = p_para_rec.bc_funds_check_status;
3079: END IF;
3080: IF p_para_rec.BC_funds_check_order_by IS NOT NULL THEN

Line 3083: FROM PSA_LOOKUP_CODES

3079: END IF;
3080: IF p_para_rec.BC_funds_check_order_by IS NOT NULL THEN
3081: SELECT meaning
3082: INTO l_funds_check_order_by
3083: FROM PSA_LOOKUP_CODES
3084: WHERE lookup_type = 'PSA_BC_FUNDS_CHECK_ORDER_BY'
3085: AND lookup_code = p_para_rec.bc_funds_check_order_by;
3086: END IF;
3087: