APPS.ARPT_SQL_FUNC_UTIL dependencies on RA_CUST_TRX_TYPES_ALL

Line 2464: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;

2460: RETURN VARCHAR2 IS
2461: l_name ra_cust_trx_types.name%type;
2462: l_type ra_cust_trx_types.type%type;
2463: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2464: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2465: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2466: l_creation_sign ra_cust_trx_types.creation_sign%type;
2467: -- Bug 4221745
2468: l_post_to_gl ra_cust_trx_types.post_to_gl%type;

Line 2492: FROM ra_cust_trx_types_all

2488: INTO l_name, l_type, l_subseq_trx_type_id,
2489: l_allow_overapplication_flag ,
2490: l_natural_application_flag,
2491: l_creation_sign, l_post_to_gl
2492: FROM ra_cust_trx_types_all
2493: WHERE cust_trx_type_id = p_trx_type_id
2494: AND org_id = p_org_id;
2495: EXCEPTION WHEN OTHERS THEN
2496: return('-99999999');

Line 2522: FROM ra_cust_trx_types_all

2518: INTO l_name, l_type, l_subseq_trx_type_id,
2519: l_allow_overapplication_flag ,
2520: l_natural_application_flag,
2521: l_creation_sign, l_post_to_gl
2522: FROM ra_cust_trx_types_all
2523: WHERE cust_trx_type_id = p_trx_type_id;
2524: EXCEPTION
2525: WHEN NO_DATA_FOUND THEN
2526: return('-99999999');

Line 3035: FROM ra_cust_trx_types_all

3031: ELSE
3032:
3033: SELECT name
3034: INTO l_trx_name
3035: FROM ra_cust_trx_types_all
3036: WHERE cust_trx_type_id = p_trx_type_id
3037: AND NVL(org_id,-99) = NVL(p_org_id,-99);
3038:
3039: