APPS.CST_PAC_WIP_VALUE_REPORT_PVT dependencies on CST_PAC_PERIODS

Line 343: cst_pac_periods cpp,

339: p_exchange_rate_char exchange_rate_char,
340: p_currency_code currency_code,
341: m1.meaning rep_type
342: FROM xle_entity_profiles xle,
343: cst_pac_periods cpp,
344: cst_cost_types cct,
345: cst_le_cost_types clct,
346: cst_cost_groups ccg,
347: mfg_lookups m1

Line 561: cst_pac_periods cpp

557:
558: SELECT nvl(max(cpp.pac_period_id), -1)
559: INTO l_prev_period_id
560: FROM cst_pac_process_phases cppp,
561: cst_pac_periods cpp
562: WHERE cppp.pac_period_id = cpp.pac_period_id
563: AND cppp.cost_group_id = p_cost_group_id
564: AND cpp.cost_type_id = p_cost_type_id
565: AND cpp.legal_entity = p_legal_entity_id

Line 863: FROM cst_pac_periods cpp

859: l_stmt_num := 10;
860:
861: SELECT cpp.period_end_date
862: INTO l_period_end_date
863: FROM cst_pac_periods cpp
864: WHERE cpp.pac_period_id = P_PAC_PERIOD_ID;
865:
866: l_stmt_num := 20;
867: