APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_RECEIVABLES_TRX

Line 3066: l_type ar_receivables_trx.type%TYPE;

3062: FUNCTION get_rec_trx_type(p_rec_trx_id IN NUMBER,
3063: p_detail_type IN VARCHAR2 DEFAULT 'TYPE')
3064: RETURN VARCHAR2 IS
3065:
3066: l_type ar_receivables_trx.type%TYPE;
3067: l_name ar_receivables_trx.name%TYPE;
3068:
3069: BEGIN
3070:

Line 3067: l_name ar_receivables_trx.name%TYPE;

3063: p_detail_type IN VARCHAR2 DEFAULT 'TYPE')
3064: RETURN VARCHAR2 IS
3065:
3066: l_type ar_receivables_trx.type%TYPE;
3067: l_name ar_receivables_trx.name%TYPE;
3068:
3069: BEGIN
3070:
3071: select type, name

Line 3073: from ar_receivables_trx

3069: BEGIN
3070:
3071: select type, name
3072: into l_type, l_name
3073: from ar_receivables_trx
3074: where receivables_trx_id = p_rec_trx_id;
3075:
3076: if p_detail_type = 'TYPE' THEN
3077: return l_type;

Line 3089: from ar_receivables_trx_all

3085: WHEN NO_DATA_FOUND THEN
3086: BEGIN
3087: select type, name
3088: into l_type, l_name
3089: from ar_receivables_trx_all
3090: where receivables_trx_id = p_rec_trx_id;
3091:
3092: if p_detail_type = 'TYPE' THEN
3093: return l_type;