APPS.EAM_FORECAST_PVT dependencies on ORG_ACCT_PERIODS

Line 105: FROM cst_distribution_lite_v cdv, wip_eam_period_balances wepb, org_acct_periods oap,

101: oap.period_start_date,
102: oap.period_num,
103: oap.period_year,
104: (cdv.base_transaction_value)as value
105: FROM cst_distribution_lite_v cdv, wip_eam_period_balances wepb, org_acct_periods oap,
106: mfg_lookups mf
107: WHERE cdv.operation_seq_num is not null
108: and mf.lookup_type = 'CST_ACCOUNTING_LINE_TYPE'
109: and mf.lookup_code in (7,8)

Line 146: FROM cst_distribution_lite_v cdv, org_acct_periods oap, wip_discrete_jobs wdj,

142: oap.period_start_date,
143: oap.period_num,
144: oap.period_year,
145: (cdv.base_transaction_value) value
146: FROM cst_distribution_lite_v cdv, org_acct_periods oap, wip_discrete_jobs wdj,
147: wip_eam_parameters ep, mfg_lookups mf
148: WHERE ep.organization_id = cdv.organization_id
149: and cdv.wip_entity_id = wdj.wip_entity_id
150: and cdv.organization_id = wdj.organization_id

Line 211: from org_acct_periods oap

207: -------------------------------------------------------------------------
208:
209: select oap.period_start_date
210: into l_period_from
211: from org_acct_periods oap
212: where organization_id = p_org_id
213: and acct_period_id = p_acct_period_from;
214:
215: select nvl(oap.period_close_date, oap.SCHEDULE_CLOSE_DATE)

Line 217: from org_acct_periods oap

213: and acct_period_id = p_acct_period_from;
214:
215: select nvl(oap.period_close_date, oap.SCHEDULE_CLOSE_DATE)
216: into l_period_to
217: from org_acct_periods oap
218: where organization_id = p_org_id
219: and acct_period_id = p_acct_period_to; */
220:
221: -------------------------------------------------------------------------