APPS.EAM_MATERIALISSUE_PVT dependencies on ORG_ACCT_PERIODS

Line 324: org_acct_periods

320: select
321: 'Y'
322: into l_within_open_period
323: FROM
324: org_acct_periods
325: WHERE
326: organization_id=p_organization_id
327: and period_close_date is null
328: and p_date between

Line 788: FROM org_acct_periods oap,

784:
785: /* Added for bug 4041420 - Start */
786: SELECT NVL(max(oap.acct_period_id), -1)
787: INTO l_acct_period_id
788: FROM org_acct_periods oap,
789: mtl_material_transactions_temp mmtt
790: WHERE mmtt.transaction_temp_id = p_trx_tmp_id
791: AND oap.organization_id = mmtt.organization_id
792: AND oap.open_flag = 'Y'