APPS.ARRX_RC dependencies on AR_RECEIVABLE_APPLICATIONS

Line 644: FROM AR_RECEIVABLE_APPLICATIONS_ALL RA

640: fa_rx_util_pkg.Where_Clause :=
641: fa_rx_util_pkg.Where_Clause ||'
642: AND ( NOT EXISTS
643: (SELECT ''App Exists''
644: FROM AR_RECEIVABLE_APPLICATIONS_ALL RA
645: WHERE CR.CASH_RECEIPT_ID = RA.CASH_RECEIPT_ID
646: AND CR.TYPE = ''CASH''
647: AND NVL(RA.CONFIRMED_FLAG, ''Y'') = ''Y''
648: AND RA.GL_DATE < :p_gl_date_low ' || L_RA_ORG_WHERE ||

Line 748: AR_RECEIVABLE_APPLICATIONS_ALL RA,

744:
745: IF NVL(var.ca_sob_type,'P') = 'P' THEN
746: fa_rx_util_pkg.From_Clause :=
747: fa_rx_util_pkg.From_Clause || ',
748: AR_RECEIVABLE_APPLICATIONS_ALL RA,
749: RA_CUSTOMER_TRX_ALL TRX,
750: RA_CUST_TRX_LINE_GL_DIST_ALL REC';
751: ELSE
752: fa_rx_util_pkg.From_Clause :=

Line 940: ', AR_RECEIVABLE_APPLICATIONS_ALL RA,

936:
937: IF NVL(var.ca_sob_type,'P') = 'P' THEN
938: fa_rx_util_pkg.From_Clause :=
939: fa_rx_util_pkg.From_Clause ||
940: ', AR_RECEIVABLE_APPLICATIONS_ALL RA,
941: RA_CUSTOMER_TRX_ALL TRX,
942: RA_CUST_TRX_LINE_GL_DIST_ALL REC,
943: HZ_CUST_ACCOUNTS_ALL RAC ,
944: AR_PAYMENT_SCHEDULES_ALL PS ,

Line 1307: from ar_receivable_applications

1303: decode(sum(decode(status,'UNAPP', amount_applied,0))
1304: , 0 , var.l_app , var.l_unapp),
1305: var.l_unid)
1306: into var.receipt_status
1307: from ar_receivable_applications
1308: where cash_receipt_id = var.cash_receipt_id;
1309: END IF;
1310: ELSE
1311: IF var.cr_status in ('REV', 'NSF', 'STOP') AND