DBA Data[Home] [Help]

APPS.HZ_EXTRACT_PARTY_USAGE_BO_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 62

	SELECT
		HZ_PARTY_USAGE_OBJ(
  		PARTY_USG_ASSIGNMENT_ID,
  		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
  		PARTY_ID,
  		PARTY_USAGE_CODE,
  		EFFECTIVE_START_DATE,
  		EFFECTIVE_END_DATE,
  		COMMENTS,
  		STATUS_FLAG,
		ATTRIBUTE_CATEGORY,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		ATTRIBUTE16,
		ATTRIBUTE17,
		ATTRIBUTE18,
		ATTRIBUTE19,
		ATTRIBUTE20,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
  		CREATION_DATE,
  		LAST_UPDATE_DATE,
  		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
	FROM HZ_PARTY_USG_ASSIGNMENTS
	WHERE PARTY_ID = P_OWNER_TABLE_ID;