DBA Data[Home] [Help]

APPS.HZ_ADDRESS_USAGES_PUB dependencies on DUAL

Line 120: FROM dual;

116: BEGIN --insert row
117:
118: SELECT HZ_ADDRESS_USAGES_S.nextval
119: INTO l_usage_id
120: FROM dual;
121:
122: hz_address_usages_pkg.insert_row(
123: l_usage_row_id,
124: l_usage_id,

Line 168: FROM dual;

164: l_geotype := p_address_usage_dtls_tbl(i).geography_type;
165:
166: SELECT HZ_ADDRESS_USAGES_S.nextval
167: INTO l_usage_dtl_id
168: FROM dual;
169:
170: hz_address_usage_dtls_pkg.insert_row(
171: x_usage_dtl_row_id,
172: l_usage_dtl_id,

Line 623: FROM dual;

619: l_geotype := p_address_usage_dtls_tbl(i).geography_type;
620:
621: SELECT HZ_ADDRESS_USAGES_S.nextval
622: INTO l_usage_dtl_id
623: FROM dual;
624:
625: hz_address_usage_dtls_pkg.insert_row(
626: x_usage_dtl_row_id,
627: l_usage_dtl_id,