DBA Data[Home] [Help]

APPS.EAM_OP_COMP_VALIDATE_PVT dependencies on ORG_ACCT_PERIODS

Line 389: FROM org_acct_periods

385: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking open period ...'); END IF;
386: BEGIN
387: SELECT NVL(MIN(period_start_date), sysdate+1)
388: INTO l_open_acct_per_date
389: FROM org_acct_periods
390: WHERE organization_id = (select organization_id from wip_discrete_jobs where wip_entity_id = p_eam_op_comp_rec.wip_entity_id)
391: AND open_flag = 'Y';
392:
393: IF sysdate < l_open_acct_per_date THEN -- p_transaction_date < l_open_acct_per_date