DBA Data[Home] [Help]

APPS.IGIRCBID dependencies on AR_RECEIVABLE_APPLICATIONS

Line 31: FROM ar_receivable_applications ra,

27:
28: CURSOR CRa IS
29: SELECT DISTINCT
30: ra.receivable_application_id
31: FROM ar_receivable_applications ra,
32: ar_cash_receipts cr
33: WHERE ra.gl_date >= p_Prepare.GlDateFrom
34: AND ra.gl_date <= p_Prepare.GlDateTo
35: AND nvl(ra.postable,'Y') = 'Y'

Line 116: FROM ar_receivable_applications ra,

112: '1', 'N',
113: '2', 'Y'
114: ) CmPsIdFlag,
115: ra.receivable_application_id
116: FROM ar_receivable_applications ra,
117: ra_cust_trx_types ctt,
118: ra_customer_trx ct,
119: ar_cash_receipts cr,
120: ar_cash_receipt_history crh,