APPS.ARPT_SQL_FUNC_UTIL dependencies on RA_CUST_TRX_TYPES_ALL

Line 2345: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;

2341: RETURN VARCHAR2 IS
2342: l_name ra_cust_trx_types.name%type;
2343: l_type ra_cust_trx_types.type%type;
2344: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2345: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2346: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2347: l_creation_sign ra_cust_trx_types.creation_sign%type;
2348: -- Bug 4221745
2349: l_post_to_gl ra_cust_trx_types.post_to_gl%type;

Line 2373: FROM ra_cust_trx_types_all

2369: INTO l_name, l_type, l_subseq_trx_type_id,
2370: l_allow_overapplication_flag ,
2371: l_natural_application_flag,
2372: l_creation_sign, l_post_to_gl
2373: FROM ra_cust_trx_types_all
2374: WHERE cust_trx_type_id = p_trx_type_id
2375: AND org_id = p_org_id;
2376: EXCEPTION WHEN OTHERS THEN
2377: return('-99999999');

Line 2403: FROM ra_cust_trx_types_all

2399: INTO l_name, l_type, l_subseq_trx_type_id,
2400: l_allow_overapplication_flag ,
2401: l_natural_application_flag,
2402: l_creation_sign, l_post_to_gl
2403: FROM ra_cust_trx_types_all
2404: WHERE cust_trx_type_id = p_trx_type_id;
2405: EXCEPTION
2406: WHEN NO_DATA_FOUND THEN
2407: return('-99999999');

Line 2916: FROM ra_cust_trx_types_all

2912: ELSE
2913:
2914: SELECT name
2915: INTO l_trx_name
2916: FROM ra_cust_trx_types_all
2917: WHERE cust_trx_type_id = p_trx_type_id
2918: AND NVL(org_id,-99) = NVL(p_org_id,-99);
2919:
2920: