DBA Data[Home] [Help]

APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_FIN_YEARS

Line 166: FROM JAI_CMN_FIN_YEARS a

162: FROM JAI_AR_TRX_INS_HDRS_T
163: WHERE customer_trx_id = v_customer_trx_id;
164: CURSOR fin_year_cur(p_org_id IN NUMBER) IS
165: SELECT MAX(a.fin_year)
166: FROM JAI_CMN_FIN_YEARS a
167: WHERE organization_id = p_org_id and fin_active_flag = 'Y';
168:
169: CURSOR matched_receipt_cur(p_customer_trx_line_id IN NUMBER) IS
170: SELECT a.receipt_id, a.quantity_applied, b.transaction_type,b.qty_to_adjust,