DBA Data[Home] [Help]

APPS.AMW_PROC_ORG_HIERARCHY_PVT dependencies on AMW_PROCESS_ORGANIZATION_S

Line 694: SELECT AMW_PROCESS_organization_s.NEXTVAL FROM dual;

690: l_obj_num number := 0;
691: process_end_date date := sysdate;
692:
693: CURSOR c_proc_org_s IS
694: SELECT AMW_PROCESS_organization_s.NEXTVAL FROM dual;
695:
696: cursor get_counts is
697: select nvl(risk_count,0) as risk_count,
698: nvl(control_count,0) as control_count from amw_process