APPS.CSTPWPVR dependencies on WIP_REPETITIVE_SCHEDULES

Line 377: wip_repetitive_schedules s,

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
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

Line 417: wip_repetitive_schedules s,

413: SYSDATE, i_user_id, SYSDATE, i_user_id, i_login_id,
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

Line 508: wip_repetitive_schedules wrs

504: wip_cost_txn_interface wcti,
505: wip_txn_allocations alloc,
506: wip_period_balances wpb,
507: cst_cost_elements cce,
508: wip_repetitive_schedules wrs
509: WHERE wcti.group_id = l_group_id
510: AND wcti.line_id IS NOT NULL
511: AND WRS.WIP_ENTITY_ID = WCTI.WIP_ENTITY_ID
512: AND wrs.line_id = wcti.line_id

Line 600: wip_repetitive_schedules wrs

596: wip_cost_txn_interface wcti,
597: wip_txn_allocations alloc,
598: wip_period_balances wpb,
599: cst_cost_elements cce,
600: wip_repetitive_schedules wrs
601: WHERE wcti.group_id = l_group_id
602: AND wcti.line_id IS NOT NULL
603: AND WRS.WIP_ENTITY_ID = WCTI.WIP_ENTITY_ID
604: AND wrs.line_id = wcti.line_id

Line 750: WIP_REPETITIVE_SCHEDULES s,

746: (SELECT i.wip_entity_id,
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