DBA Data[Home] [Help]

APPS.CSTPPCIC dependencies on CST_PAC_PROCESS_PHASES

Line 283: from cst_pac_process_phases cppp

279: where legal_entity = p_legal_entity
280: and cost_type_id = p_from_cost_type_id
281: and cpp.pac_period_id in
282: (select cppp.pac_period_id
283: from cst_pac_process_phases cppp
284: where cppp.cost_group_id = p_from_cost_group_id
285: and cppp.pac_period_id = cpp.pac_period_id
286: and process_phase = 5
287: and process_status = 4

Line 305: from cst_pac_process_phases

301: into l_valid
302: from dual
303: where p_period_id in
304: (select distinct pac_period_id
305: from cst_pac_process_phases
306: where cost_group_id = p_from_cost_group_id
307: and process_phase = 5
308: and process_status = 4
309: );