APPS.CSTPWPVR dependencies on ORG_ACCT_PERIODS

Line 78: org_acct_periods oa,

74: i_close_period_id, 5,
75: oa.schedule_close_date, l_group_id,
76: NULL
77: FROM wip_period_balances b,
78: org_acct_periods oa,
79: wip_discrete_jobs j
80: WHERE b.class_type IN (4,6) -- Bug #2357983.
81: /* modified for EAM (class_type = 6); modified for OSFM (class_type = 7) */
82: AND b.acct_period_id = i_close_period_id

Line 371: org_acct_periods oa

367: i_close_period_id, 5,
368: oa.schedule_close_date, l_group_id,
369: wri.line_id
370: FROM wip_repetitive_items wri,
371: org_acct_periods oa
372: WHERE oa.organization_id = i_org_id
373: AND oa.acct_period_id = i_close_period_id
374: AND (wri.wip_entity_id, wri.line_id) IN
375: (SELECT s.wip_entity_id, s.line_id

Line 378: org_acct_periods a

374: AND (wri.wip_entity_id, wri.line_id) IN
375: (SELECT s.wip_entity_id, s.line_id
376: FROM wip_period_balances b,
377: wip_repetitive_schedules s,
378: org_acct_periods a
379: WHERE b.acct_period_id = i_close_period_id
380: /* only if the schedule has a balance row in this period */
381: AND b.organization_id = i_org_id
382: AND b.class_type = 2

Line 418: org_acct_periods a

414: 0, 0
415: FROM wip_cost_txn_interface i,
416: wip_period_balances b,
417: wip_repetitive_schedules s,
418: org_acct_periods a
419: WHERE i.group_id = l_group_id
420: AND i.line_id IS NOT NULL
421: AND S.WIP_ENTITY_ID = I.WIP_ENTITY_ID
422: AND s.line_id = i.line_id

Line 751: ORG_ACCT_PERIODS oap

747: alloc.repetitive_schedule_id
748: FROM WIP_COST_TXN_INTERFACE i,
749: WIP_TXN_ALLOCATIONS alloc,
750: WIP_REPETITIVE_SCHEDULES s,
751: ORG_ACCT_PERIODS oap
752: WHERE i.group_id = l_group_id
753: AND i.line_id IS NOT NULL
754: AND i.transaction_id = alloc.transaction_id
755: AND alloc.repetitive_schedule_id = s.repetitive_schedule_id