DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on ORG_ACCT_PERIODS

Line 990: FROM org_acct_periods

986: WHERE transaction_type_name = cp_transaction_type_name;
987:
988: CURSOR c_account_period_id(cp_organization_id IN NUMBER, cp_transaction_date IN DATE) IS
989: SELECT acct_period_id
990: FROM org_acct_periods
991: WHERE period_close_date is null
992: AND organization_id = cp_organization_id
993: AND trunc(schedule_close_date) >= trunc(nvl(cp_transaction_date,sysdate))
994: AND trunc(period_start_date) <= trunc(nvl(cp_transaction_date,sysdate));