DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on ORG_ACCT_PERIODS

Line 1046: FROM org_acct_periods

1042: WHERE transaction_type_name = cp_transaction_type_name;
1043:
1044: CURSOR c_account_period_id(cp_organization_id IN NUMBER, cp_transaction_date IN DATE) IS
1045: SELECT acct_period_id
1046: FROM org_acct_periods
1047: WHERE period_close_date is null
1048: AND organization_id = cp_organization_id
1049: AND trunc(schedule_close_date) >= trunc(nvl(cp_transaction_date,sysdate))
1050: AND trunc(period_start_date) <= trunc(nvl(cp_transaction_date,sysdate));