DBA Data[Home] [Help]

APPS.EAM_OP_COMP_VALIDATE_PVT dependencies on ORG_ACCT_PERIODS

Line 380: FROM org_acct_periods

376: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking open period ...'); END IF;
377: BEGIN
378: SELECT NVL(MIN(period_start_date), sysdate+1)
379: INTO l_open_acct_per_date
380: FROM org_acct_periods
381: WHERE organization_id = (select organization_id from wip_discrete_jobs where wip_entity_id = p_eam_op_comp_rec.wip_entity_id)
382: AND open_flag = 'Y';
383:
384: IF sysdate < l_open_acct_per_date THEN -- p_transaction_date < l_open_acct_per_date