APPS.CSTPPBBS dependencies on WIP_PAC_PERIOD_BALANCES

Line 196: FROM wip_pac_period_balances

192: l_stmt_num := 20;
193: l_count := 0;
194: SELECT count(1)
195: INTO l_count
196: FROM wip_pac_period_balances
197: WHERE pac_period_id = i_pac_period_id
198: AND cost_group_id = i_cost_group_id
199: AND rownum = 1;
200:

Line 496: -- Copy prior info of wip_pac_period_balances --

492: AND cpql.cost_group_id = cpic.cost_group_id
493: AND cpql.pac_period_id = cpic.pac_period_id);
494:
495: ---------------------------------------------------------------------------
496: -- Copy prior info of wip_pac_period_balances --
497: -- Only the followings are copied : --
498: -- 1. Discrete jobs that are opened or closed in the current period. --
499: -- 2. Scheduled CFM that are opened or closed in the current period. --
500: -- 3. Repetitive Schedules having at least line that are opened or --

Line 512: INSERT INTO wip_pac_period_balances (

508: FROM CST_PAC_PERIODS
509: WHERE pac_period_id = i_pac_period_id;
510:
511: l_stmt_num := 70;
512: INSERT INTO wip_pac_period_balances (
513: pac_period_id,
514: cost_group_id,
515: cost_type_id,
516: organization_id,

Line 634: wip_pac_period_balances wppb, wip_entities we

630: i_prog_id,
631: SYSDATE,
632: i_login_id
633: FROM
634: wip_pac_period_balances wppb, wip_entities we
635: WHERE
636: wppb.pac_period_id = i_prior_pac_period_id
637: AND wppb.cost_group_id = i_cost_group_id
638: AND wppb.wip_entity_id = we.wip_entity_id