APPS.PSA_MFAR_VAL_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 223: from psa_trx_types_ALL a, ra_customer_trx_all b

219: return;
220: end if;
221:
222: SELECT 'X' into l_trx_type_check
223: from psa_trx_types_ALL a, ra_customer_trx_all b
224: where a.psa_trx_type_id = b.cust_trx_type_id
225: and b.customer_trx_id = X_TRX_ID ;
226:
227: if l_trx_type_check is not null then

Line 320: from psa_trx_types_ALL a, ra_customer_trx_all b

316:
317: if X_SOURCE_TYPE = 'TRX' then
318:
319: SELECT 'X' into l_validate_trx
320: from psa_trx_types_ALL a, ra_customer_trx_all b
321: where a.psa_trx_type_id = b.cust_trx_type_id
322: and customer_trx_id = X_SOURCE_ID ;
323:
324: if l_validate_trx is not null then

Line 335: from psa_trx_types_ALL a, ra_customer_trx_all b,

331:
332: elsif X_SOURCE_TYPE = 'ADJ' then
333:
334: SELECT 'X' into l_validate_adj
335: from psa_trx_types_ALL a, ra_customer_trx_all b,
336: ar_adjustments_all c
337: where b.customer_trx_id = c.customer_trx_id
338: and a.psa_trx_type_id = b.cust_trx_type_id
339: and c.adjustment_id = X_SOURCE_ID ;

Line 403: from psa_trx_types_ALL a, ra_customer_trx_ALL b

399:
400: fnd_profile.get('ORG_ID',l_org_id);
401:
402: SELECT 'X' into l_rct_check
403: from psa_trx_types_ALL a, ra_customer_trx_ALL b
404: -- ar_cash_receipts_ALL c,ar_receivable_applications_ALL d
405: -- where b.customer_trx_id = d.applied_customer_trx_id
406: -- and c.cash_receipt_id = d.cash_receipt_id
407: -- and

Line 427: from ra_customer_trx_all

423: -- Modified this sql to include org_id
424: -- Bug 2374853
425:
426: Select Invoice_currency_code into l_inv_currency_code
427: from ra_customer_trx_all
428: where customer_trx_id = X_TRANSACTION_ID and
429: org_id = l_org_id;
430:
431: