APPS.CSTPFCHK dependencies on WIP_PAC_PERIOD_BALANCES

Line 1030: FROM wip_pac_period_balances wppb

1026: WHERE cpql.cost_layer_id = P_cost_layer_id;
1027:
1028: CURSOR prior_period_jobs_cursor IS
1029: SELECT distinct(wip_entity_id)
1030: FROM wip_pac_period_balances wppb
1031: WHERE wppb.pac_period_id = i_prior_pac_period_id
1032: AND wppb.cost_group_id = i_cost_group_id;
1033:
1034: l_file VARCHAR2(100);

Line 1076: FROM wip_pac_period_balances

1072: l_stmt_num := 20;
1073: l_count := 0;
1074: SELECT count(*)
1075: INTO l_count
1076: FROM wip_pac_period_balances
1077: WHERE pac_period_id = i_pac_period_id
1078: AND cost_group_id = i_cost_group_id;
1079:
1080: IF (l_count <> 0) THEN

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

1286:
1287: END LOOP;
1288:
1289: ---------------------------------------------------------------------------
1290: -- Copy prior info of wip_pac_period_balances --
1291: -- Only the followings are copied : --
1292: -- 1. Discrete jobs that are opened or closed in the current period. --
1293: -- 2. Scheduled CFM that are opened or closed in the current period. --
1294: -- 3. Repetitive Schedules having at least line that are opened or --

Line 1306: INSERT INTO wip_pac_period_balances (

1302: FROM CST_PAC_PERIODS
1303: WHERE pac_period_id = i_pac_period_id;
1304:
1305: l_stmt_num := 70;
1306: INSERT INTO wip_pac_period_balances (
1307: pac_period_id,
1308: cost_group_id,
1309: cost_type_id,
1310: organization_id,

Line 1413: wip_pac_period_balances wppb, wip_entities we

1409: i_prog_id,
1410: SYSDATE,
1411: i_login_id
1412: FROM
1413: wip_pac_period_balances wppb, wip_entities we
1414: WHERE
1415: wppb.pac_period_id = i_prior_pac_period_id
1416: AND wppb.cost_group_id = i_cost_group_id
1417: AND wppb.wip_entity_id = we.wip_entity_id