APPS.HZ_AIA_CUSTOM_PKG dependencies on HZ_CUST_SITE_USES_S

Line 878: select HZ_CUST_SITE_USES_S.NEXTVAL into l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs(k).site_use_id from dual;

874: l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs.COUNT > 0 AND
875: l_su_profile = 'N') THEN
876: FOR k IN 1..l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs.COUNT LOOP
877: IF(l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs(k).location IS NULL) THEN
878: select HZ_CUST_SITE_USES_S.NEXTVAL into l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs(k).site_use_id from dual;
879: l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs(k).location := to_char(l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs(k).site_use_id);
880: END IF;
881: END LOOP;
882: END IF;