APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_RECEIVABLES_TRX

Line 2946: l_type ar_receivables_trx.type%TYPE;

2942: FUNCTION get_rec_trx_type(p_rec_trx_id IN NUMBER,
2943: p_detail_type IN VARCHAR2 DEFAULT 'TYPE')
2944: RETURN VARCHAR2 IS
2945:
2946: l_type ar_receivables_trx.type%TYPE;
2947: l_name ar_receivables_trx.name%TYPE;
2948:
2949: BEGIN
2950:

Line 2947: l_name ar_receivables_trx.name%TYPE;

2943: p_detail_type IN VARCHAR2 DEFAULT 'TYPE')
2944: RETURN VARCHAR2 IS
2945:
2946: l_type ar_receivables_trx.type%TYPE;
2947: l_name ar_receivables_trx.name%TYPE;
2948:
2949: BEGIN
2950:
2951: select type, name

Line 2953: from ar_receivables_trx

2949: BEGIN
2950:
2951: select type, name
2952: into l_type, l_name
2953: from ar_receivables_trx
2954: where receivables_trx_id = p_rec_trx_id;
2955:
2956: if p_detail_type = 'TYPE' THEN
2957: return l_type;

Line 2969: from ar_receivables_trx_all

2965: WHEN NO_DATA_FOUND THEN
2966: BEGIN
2967: select type, name
2968: into l_type, l_name
2969: from ar_receivables_trx_all
2970: where receivables_trx_id = p_rec_trx_id;
2971:
2972: if p_detail_type = 'TYPE' THEN
2973: return l_type;