APPS.CST_JOBCLOSEVAR_GRP dependencies on WIP_COST_TXN_INTERFACE

Line 72: FROM WIP_COST_TXN_INTERFACE

68: l_index NUMBER;
69:
70: CURSOR c_transactions IS
71: SELECT TRANSACTION_ID
72: FROM WIP_COST_TXN_INTERFACE
73: WHERE GROUP_ID = p_wcti_group_id;
74:
75: BEGIN
76:

Line 271: FROM wip_cost_txn_interface wcti,

267: p_req_id,
268: p_prg_appl_id,
269: p_prg_id,
270: sysdate
271: FROM wip_cost_txn_interface wcti,
272: wip_period_balances wpb,
273: wip_discrete_jobs wdj,
274: cst_cost_elements cce
275: --{BUG#13072387

Line 405: FROM wip_cost_txn_interface wcti,

401: p_req_id,
402: p_prg_appl_id,
403: p_prg_id,
404: SYSDATE
405: FROM wip_cost_txn_interface wcti,
406: wip_period_balances wpb,
407: wip_discrete_jobs wdj,
408: cst_cost_elements cce
409: --{BUG#13072387

Line 561: FROM wip_cost_txn_interface i

557: WHERE (wpb.acct_period_id,
558: wpb.wip_entity_id)
559: IN (SELECT i.acct_period_id,
560: i.wip_entity_id
561: FROM wip_cost_txn_interface i
562: WHERE i.group_id = p_wcti_group_id);
563:
564: /*------------------------------------------------------------------------+
565: | Get the primary costing method of the Organization. |

Line 595: FROM wip_cost_txn_interface wcti

591: AND w.operation_seq_num = w2.operation_seq_num
592: AND w.cost_element_id = w2.cost_element_id )
593: WHERE w.wip_entity_id
594: IN (SELECT wip_entity_id
595: FROM wip_cost_txn_interface wcti
596: WHERE wcti.group_id = p_wcti_group_id );
597:
598: UPDATE wip_operation_resources w
599: SET (relieved_variance_value)

Line 610: FROM wip_cost_txn_interface wcti

606: AND w.operation_seq_num = w2.operation_seq_num
607: AND w.resource_seq_num = w2.resource_seq_num)
608: WHERE w.wip_entity_id
609: IN (SELECT wip_entity_id
610: FROM wip_cost_txn_interface wcti
611: WHERE wcti.group_id = p_wcti_group_id);
612:
613: UPDATE wip_operation_overheads w
614: SET (relieved_variance_value)

Line 627: FROM wip_cost_txn_interface wcti

623: AND w.overhead_id = w2.overhead_id
624: AND w.basis_type = w2.basis_type )
625: WHERE w.wip_entity_id
626: IN (SELECT wip_entity_id
627: FROM wip_cost_txn_interface wcti
628: WHERE wcti.group_id = p_wcti_group_id);
629: END IF;
630:
631: /*------------------------------------------------------------------------+

Line 643: FROM wip_cost_txn_interface i,

639: wpb.wip_entity_id)
640: IN
641: (SELECT a.acct_period_id,
642: i.wip_entity_id
643: FROM wip_cost_txn_interface i,
644: org_acct_periods a
645: --{BUG#13072387
646: , org_acct_periods f
647: --}

Line 659: | Copy rows from wip_cost_txn_interface to wip_transactions and |

655: --}
656: AND a.organization_id = i.organization_id);
657:
658: /*------------------------------------------------------------------------+
659: | Copy rows from wip_cost_txn_interface to wip_transactions and |
660: | delete from wip_cost_txn_interface. |
661: +------------------------------------------------------------------------*/
662: l_stmt_num := 90;
663:

Line 660: | delete from wip_cost_txn_interface. |

656: AND a.organization_id = i.organization_id);
657:
658: /*------------------------------------------------------------------------+
659: | Copy rows from wip_cost_txn_interface to wip_transactions and |
660: | delete from wip_cost_txn_interface. |
661: +------------------------------------------------------------------------*/
662: l_stmt_num := 90;
663:
664: l_err_num := CSTPWCPX.CMLCPX(p_wcti_group_id,