APPS.RRS_SITE_GROUP_NODES_PKG dependencies on RRS_SITES_S

Line 24: select nvl(X_SITE_GROUP_NODE_ID ,RRS_SITES_S.nextval)

20: where SITE_GROUP_NODE_ID = L_SITE_GROUP_NODE_ID;
21:
22: begin
23:
24: select nvl(X_SITE_GROUP_NODE_ID ,RRS_SITES_S.nextval)
25: into L_SITE_GROUP_NODE_ID
26: from dual;
27:
28: insert into RRS_SITE_GROUP_NODES_B (