DBA Data[Home] [Help]

APPS.HZ_PARTY_USAGES_PKG dependencies on HZ_PARTY_USAGES_B

Line 23: INSERT INTO hz_party_usages_b (

19: ) IS
20:
21: BEGIN
22:
23: INSERT INTO hz_party_usages_b (
24: party_usage_code,
25: party_usage_type,
26: restrict_manual_assign_flag,
27: restrict_manual_update_flag,

Line 116: UPDATE hz_party_usages_b

112: ) IS
113:
114: BEGIN
115:
116: UPDATE hz_party_usages_b
117: SET
118: party_usage_type = x_party_usage_type,
119: restrict_manual_assign_flag =
120: DECODE(x_restrict_manual_assign_flag,

Line 182: FROM hz_party_usages_b b

178:
179: DELETE FROM hz_party_usages_tl t
180: WHERE NOT EXISTS (
181: SELECT NULL
182: FROM hz_party_usages_b b
183: WHERE b.party_usage_code = t.party_usage_code
184: );
185:
186: UPDATE hz_party_usages_tl t

Line 345: FROM hz_party_usages_b

341: f_ludate DATE; -- entity update date in file
342:
343: CURSOR c_party_usage IS
344: SELECT object_version_number
345: FROM hz_party_usages_b
346: WHERE party_usage_code = x_party_usage_code;
347:
348: db_object_version_number NUMBER;
349: