APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_PAC_PERIODS

Line 1179: FROM CST_PAC_PERIODS cpp

1175: );
1176:
1177: SELECT count(1)
1178: INTO l_count
1179: FROM CST_PAC_PERIODS cpp
1180: WHERE cpp.pac_period_id = p_period_id
1181: AND TRUNC(cpp.period_end_date) >= l_process_upto_date
1182: AND TRUNC(cpp.period_start_date) <= l_process_upto_date;
1183:

Line 1421: FROM cst_pac_periods cpp

1417: SELECT TO_CHAR(period_start_date,'YYYY/MM/DD HH24:MI:SS')
1418: ,p_process_upto_date
1419: INTO l_start_date
1420: ,l_end_date
1421: FROM cst_pac_periods cpp
1422: WHERE cpp.pac_period_id = p_period_id
1423: AND cpp.legal_entity = p_legal_entity
1424: AND cpp.cost_type_id = p_cost_type_id;
1425:

Line 1527: FROM cst_pac_periods cpp

1523: END IF;
1524:
1525: SELECT nvl(max(cpp.pac_period_id), -1)
1526: INTO l_prev_period_id
1527: FROM cst_pac_periods cpp
1528: WHERE cpp.legal_entity = p_legal_entity
1529: AND cpp.cost_type_id = p_cost_type_id
1530: AND cpp.pac_period_id < p_period_id;
1531:

Line 1537: FROM cst_pac_periods cpp

1533: THEN
1534:
1535: SELECT count(1)
1536: INTO l_period_closed
1537: FROM cst_pac_periods cpp
1538: WHERE cpp.pac_period_id = l_prev_period_id
1539: AND cpp.legal_entity = p_legal_entity
1540: AND cpp.cost_type_id = p_cost_type_id
1541: AND cpp.open_flag = 'N'

Line 1604: FROM cst_pac_periods cpp

1600: END IF;
1601:
1602: SELECT count(1)
1603: INTO l_count
1604: FROM cst_pac_periods cpp
1605: WHERE cpp.legal_entity = p_legal_entity
1606: AND cpp.cost_type_id = p_cost_type_id
1607: AND cpp.pac_period_id = p_period_id
1608: AND cpp.open_flag = 'Y'

Line 2802: FROM mtl_material_transactions mmt, cst_pac_periods cpp, cst_cost_groups ccg

2798: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
2799: AND cpllc.pac_period_id = p_period_id)
2800: UNION ALL
2801: SELECT mmt.inventory_item_id inventory_item_id
2802: FROM mtl_material_transactions mmt, cst_pac_periods cpp, cst_cost_groups ccg
2803: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2804: AND mmt.transaction_action_id = 24
2805: AND mmt.transaction_source_type_id = 14
2806: AND mmt.transaction_type_id = 26