[Home] [Help]
1991: --hca.party_id
1992: hca.cust_account_id
1993: INTO l_reference_4,
1994: l_reference_7
1995: FROM ar_adjustments_all ara,
1996: ar_cash_receipts_all acr,
1997: hz_cust_site_uses_all hcsu,
1998: hz_cust_acct_sites_all hcas,
1999: hz_cust_accounts hca
3129: FROM gl_je_headers
3130: WHERE je_header_id = p_je_header_id;
3131: CURSOR Receivables_Adjustment IS
3132: SELECT apply_date, creation_date, created_by
3133: FROM ar_adjustments_all
3134: WHERE adjustment_id = l_refer2;
3135: CURSOR Receivables_CMA IS
3136: SELECT apply_date, creation_date, created_by
3137: FROM ar_receivable_applications_all