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 1071: FROM wip_pac_period_balances

1067: l_stmt_num := 20;
1068: l_count := 0;
1069: SELECT count(*)
1070: INTO l_count
1071: FROM wip_pac_period_balances
1072: WHERE pac_period_id = i_pac_period_id
1073: AND cost_group_id = i_cost_group_id;
1074:
1075: IF (l_count <> 0) THEN

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

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

Line 1301: INSERT INTO wip_pac_period_balances (

1297: FROM CST_PAC_PERIODS
1298: WHERE pac_period_id = i_pac_period_id;
1299:
1300: l_stmt_num := 70;
1301: INSERT INTO wip_pac_period_balances (
1302: pac_period_id,
1303: cost_group_id,
1304: cost_type_id,
1305: organization_id,

Line 1408: wip_pac_period_balances wppb, wip_entities we

1404: i_prog_id,
1405: SYSDATE,
1406: i_login_id
1407: FROM
1408: wip_pac_period_balances wppb, wip_entities we
1409: WHERE
1410: wppb.pac_period_id = i_prior_pac_period_id
1411: AND wppb.cost_group_id = i_cost_group_id
1412: AND wppb.wip_entity_id = we.wip_entity_id