[Home] [Help]
991: l_closing_pac_period_id NUMBER,
992: l_entity_id NUMBER,
993: l_cost_type_id NUMBER) IS
994: SELECT count(1)
995: FROM wip_transactions wt
996: WHERE wt.creation_date > ( SELECT MIN(cppp.process_date)
997: FROM cst_pac_process_phases cppp
998: WHERE
999: (( cppp.process_phase <= 5