DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on ORG_ACCT_PERIODS

Line 648: l_acct_period_id org_acct_periods.acct_period_id%TYPE;

644: l_transaction_action_id mtl_transaction_types.transaction_action_id%TYPE;
645: l_transaction_source_type_id mtl_transaction_types.transaction_source_type_id%TYPE;
646: l_transaction_header_id mtl_transactions_interface.transaction_header_id%TYPE;
647: l_transaction_interface_id mtl_transactions_interface.transaction_interface_id%TYPE;
648: l_acct_period_id org_acct_periods.acct_period_id%TYPE;
649: l_quantity NUMBER;
650: l_account_id NUMBER;
651: l_code_comb_id NUMBER;
652: l_subinv_type NUMBER;

Line 697: FROM org_acct_periods

693:
694:
695: CURSOR l_acct_period_csr is
696: SELECT acct_period_id
697: FROM org_acct_periods
698: WHERE trunc(period_start_date) <= trunc(p_transaction_date)
699: AND trunc(schedule_close_date) >= trunc(p_transaction_date)
700: AND organization_id = p_organization_id
701: AND period_close_date is null