APPS.PSA_BC_XML_REPORT_PUB dependencies on PSA_LOOKUP_CODES

Line 3136: l_funds_check_status PSA_LOOKUP_CODES.meaning%TYPE;

3132: l_api_name VARCHAR2(240);
3133: l_para_meaning_list VARCHAR2(2000);
3134: l_ledger_name GL_LEDGERS.name%TYPE;
3135: l_application_short_name VARCHAR2(8);
3136: l_funds_check_status PSA_LOOKUP_CODES.meaning%TYPE;
3137: l_funds_check_order_by PSA_LOOKUP_CODES.meaning%TYPE;
3138: l_offset INTEGER;
3139:
3140: BEGIN

Line 3137: l_funds_check_order_by PSA_LOOKUP_CODES.meaning%TYPE;

3133: l_para_meaning_list VARCHAR2(2000);
3134: l_ledger_name GL_LEDGERS.name%TYPE;
3135: l_application_short_name VARCHAR2(8);
3136: l_funds_check_status PSA_LOOKUP_CODES.meaning%TYPE;
3137: l_funds_check_order_by PSA_LOOKUP_CODES.meaning%TYPE;
3138: l_offset INTEGER;
3139:
3140: BEGIN
3141: l_api_name := g_full_path||'construct_bc_report_output';

Line 3163: FROM PSA_LOOKUP_CODES

3159: END IF;
3160: IF p_para_rec.bc_funds_check_status IS NOT NULL THEN
3161: SELECT meaning
3162: INTO l_funds_check_status
3163: FROM PSA_LOOKUP_CODES
3164: WHERE lookup_type = 'PSA_BC_FUNDS_CHECK_STATUS'
3165: AND lookup_code = p_para_rec.bc_funds_check_status;
3166: END IF;
3167: IF p_para_rec.BC_funds_check_order_by IS NOT NULL THEN

Line 3170: FROM PSA_LOOKUP_CODES

3166: END IF;
3167: IF p_para_rec.BC_funds_check_order_by IS NOT NULL THEN
3168: SELECT meaning
3169: INTO l_funds_check_order_by
3170: FROM PSA_LOOKUP_CODES
3171: WHERE lookup_type = 'PSA_BC_FUNDS_CHECK_ORDER_BY'
3172: AND lookup_code = p_para_rec.bc_funds_check_order_by;
3173: END IF;
3174: